Macro to Auto Sum & Auto Print Unique Values

[mst3kr]

Hello! I need a macro that will look through the Bidder # column, pull out each unique value, sum up the values in the $ Bid column, Auto Print the Bidder information (both the totals and the unique items they've won) using an Invoice-esque page (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!

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

<TBODY>
</TBODY>

Many thanks in advance for any help!
-Greg

 

[Dryver14]

Not sure I can provide the full answer to this but having seen this in operation are you looking for unique values or highest or lowest unique values?

 

[mst3kr]

Dryver - Unique. Essentially, I need the macro to recognize each unique Bidder #, sum up the values in the $ Bid column for each unique Bidder #, then do the Auto-Print. Afterwards, repeat the process with the next unique Bidder # until it has exhausted all of the unique Bidder #'s.