Macro - find dups & add
 

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?

Macro - find dups & add
 

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?

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?