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!


[TABLE="width: 301"]
<TBODY>[TR]
[TD]Item #</SPAN>
[/TD]
[TD]Item</SPAN>
[/TD]
[TD]Bidder #</SPAN>
[/TD]
[TD]$ Bid</SPAN>
[/TD]
[/TR]
[TR]
[TD]1</SPAN>
[/TD]
[TD]Hat</SPAN>
[/TD]
[TD]456</SPAN>
[/TD]
[TD]$450.00</SPAN>
[/TD]
[/TR]
[TR]
[TD]2</SPAN>
[/TD]
[TD]Shorts</SPAN>
[/TD]
[TD]345</SPAN>
[/TD]
[TD]$200.00</SPAN>
[/TD]
[/TR]
[TR]
[TD]3</SPAN>
[/TD]
[TD]Bike</SPAN>
[/TD]
[TD]333</SPAN>
[/TD]
[TD]$4.00</SPAN>
[/TD]
[/TR]
[TR]
[TD]4</SPAN>
[/TD]
[TD]Cap</SPAN>
[/TD]
[TD]222</SPAN>
[/TD]
[TD]$66.00</SPAN>
[/TD]
[/TR]
[TR]
[TD]5</SPAN>
[/TD]
[TD]TV</SPAN>
[/TD]
[TD]456</SPAN>
[/TD]
[TD]$323.00</SPAN>
[/TD]
[/TR]
[TR]
[TD]6</SPAN>
[/TD]
[TD]Radio</SPAN>
[/TD]
[TD]333</SPAN>
[/TD]
[TD]$55.00</SPAN>
[/TD]
[/TR]
[TR]
[TD]7</SPAN>
[/TD]
[TD]Couch</SPAN>
[/TD]
[TD]555</SPAN>
[/TD]
[TD]$150.00</SPAN>
[/TD]
[/TR]
[TR]
[TD]8</SPAN>
[/TD]
[TD]Toaster</SPAN>
[/TD]
[TD]333</SPAN>
[/TD]
[TD]$75.00</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]

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.