Sum value corresponding to cells containing duplicate text

[jameswilliammitchell]

I have a command button that copies construction materials from a data entry worksheet to a summary worksheet. I need to add to the command button a code that will allow me to sum the values associated with materials that may have been entered multiple times by the user on the data entry worksheet The problem is the text relating to the material is across columns A to D and I need the quantity and the materials carbon emissions summed together .

Any Help will be appreciated thank you, I am a relatively inexperienced user of VBA.

James

 

[jameswilliammitchell]

So the description of the material is in columns A to D, the quantity is in column E and the carbon emissions in F
so if a particular material turns up more than once I need the quantity and carbon emissions of all the entries for that material to be added together and displayed as one entry