I am trying to use a macro to sum all duplicates, then delete all but one. I have data in column A that is duplicated, totals in column B that I would like summed. I can add al into B or sum in C, I would then like all of the dupes to be deleted (except one with the sum, of course). I tried Pivot Tables and couldn't make them work.


Column A Column B Column C
Invoice Gross Amt Gross amt no Dupes
1234 100.00
1234 -50.00
1245 200.00
1245 -50.00
1234 25.00