Macro to Auto Sum & Auto Print Unique Values

Hello! Below is an example of a spreadsheet I will be creating for a charity event that I need to auto-print "invoices" for after the event is over.

Item # Item Bidder # $ Bid
1 Hat 456 $450.00
2 Shorts 345 $200.00
3 Bike 333 $4.00
4 Cap 222 $66.00
5 TV 456 $323.00
6 Radio 333 $55.00
7 Couch 555 $150.00
8 Toaster 333 $75.00


Essentially, I need a macro that will look through the Bidder # column, pull out each unique value, sum up the values in the $ Bid column for each unique Bidder #, Auto-Print the Bidder information (both a total for all items won, and a list of each of the items they've won) using an invoice-esque layout (that I have yet to create), and then repeat the above steps based on the next unique Bidder #.

The macro would need to continue through the Bidder # list until it had printed all of the unique Bidder # values.

I've tried to piece-meal several macros I've found online but haven't found a combination that works. So, I'm turning to the experts!

Many thanks in advance for any help!
-Greg

edit: too slow

I'd thought about doing a Pivot Table but couldn't figure out how to do the auto populate based on changing the Bidder #. So, that is great! The only part missing is auto-printing, but I can work around that. "Manually" printing will work just fine now that I have the auto-update option that you created with the macro. Thank you very, very much! : )

I was asked to run an excel spreadsheet for a non-profit annual live auction. The above sheet "Auction Bid sums.xlsm" is perfect and needs no changes...however, being a fairly basic person regarding excel functions, I can't figure out how to make Columns E and F (Row labels and Sum of bid price) recalculate when I fill in my own figures.