Calculate the total of a unique item and place in column G and make remaining items 0

Hi,

I have to calculate the total of a unique item listed in column E and display its total in column G for the first unique item and then make the remaining unique items with a 0 in column G

I have attached an example showing the data before runnning VBA and after VBA is applied.

Excel 2003 is being used.

Thanks for any help,

David

Sorry posted to wrong group will cancel/solved