SampleWS.xlsx

Here is a sample worksheet. In column H, there will be duplicate values (names) where a customer ordered multiple items in one order OR placed multiple separate orders. I want to add the amounts in column E for all the rows with the same name in Column H then delete the remaining rows for that name.

For example on "Universal Media Sales" The row would read:

Oct-01-12 Product G,I,J 4 $xx.xx $66.84 ZZZZZZZZ UniversalMediaSales Universal Media Sales Universal Media Sales

Thanks again for the help, I've been working on this forever!