Hi,

I'm having a trouble finding a macros to help me sort through a ton of data. Here's my problem: Column A contains part numbers. These are mostly duplicate part numbers. Column B contains corresponding quantities for those part numbers. I need to figure out a way to remove duplicate part numbers, while adding up all quantities associated with that PN.

Any help is much appreciated! Thank you!!