How do you combine duplicate data in excel with a macro or VBA?

I have two columns of data in an excel spreadsheet as follows:


Contractor ID # Order Total
1521 120.00
1522 120.00
1523 30.00
1524 30.00
1523 0.00
1521 30.00
1522 30.00
1526 30.00
1527 30.00
1528 30.00




I want to perform a function that combines all the same ID #s with a total for their orders

I envision the result would look like this:

Contractor ID # Order Total
1521 150.00
1522 150.00
1523 30.00
1524 30.00
1526 30.00
1527 30.00
1528 30.00






I know that I can sort the columns from low to high. What tools do I use to automate combining the duplicate number in column 1 with their total related data in column 2?

Have a look at this thread.

It does something similar to what you want to do.

Regards