Macro - find dups & add

B

Benjamin

I have a worksheet with columns Part and Qty. Some Parts have multiple
entries. I need a macro to find the multiple entires and sum the Qty,
creating only one entry per Part. This data will then pass through a macro
being copied and pasted into another table.
Any help?
 
J

Jason

You could use a pivot table rather than writing a macro to do it. Set it up
with part for your rows and Qty for your data.
 
B

Benjamin

This works fine, but I would like to find a way to automate the process. I
have many worksheets to do this to.
 
Top