Grouping Part Numbers

Hi, I have a program that exports all part numbers for a project, along with quantities, into excel. This program is basic, and if I have one part number called out 6 times, with 6 different quantities (or the same) it will put it into the spreadsheet 6 different times. Is there a way to sort, then combine each part number, so I only see each part number once, with the total quantity? I have a bit of programming experience, but none with excel, so if someone can just get me started in the right direction it would be much appreciated.

Thanks,
Alan

ItsAlan,

If the data has headers, part numbers are in column A, and Quantity in column B, you should be able to use the following macro:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar