Macro - find dups & add
This works fine, but I would like to find a way to automate the process. I
have many worksheets to do this to.
"Jason" wrote:
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.
"Benjamin" wrote:
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?
|