Macro - find dups & add

  • Thread starter Thread starter Benjamin
  • Start date Start date
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?
 
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.
 
This works fine, but I would like to find a way to automate the process. I
have many worksheets to do this to.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy and Fill to another column 5
Multiple lookup criteria 3
Copy / paste only specific rows 3
creating labels with excel and mail merge 4
Tracking Sheet 1
Use macro to write formula 1
Selected date from a list 1
compile data from CSV 1

Back
Top