Here is what i am trying to do.

I have 3 columns. Column "A" takes in part numbes. Column "B" takes in quantities, and Column "C" contains the origin of the part.

I wrote a macro to sort based on the Origin of all data entered, but it there are 2 like part numbers, it lists them twice.

Example

Cat 1 Animal
Cat 2 Animal
Dog 1 Animal
Car 1 Transportation

The animal names being part numbers


I want to be able to add another part onto my macro to automaically cominbed multiple instances. So instead of it showing two instances of "Cat", it shows one instance of "Cat" but with the total quantity of 3.


~BCR~