Sorting based on corresponding cell

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~

Hi

1) Can we see your existing code
2) Where do you want the consolidated output to appear?

rylo

Hi

Time for an example workbook. The first sheet can show your raw data, and the second sheet shows how you want the output structured. Sorting the data in place is not going to cumulate duplicate items, just arrange them together. If you want to cumulate, then you will have to create a unique list somewhere, then bring in the cumulated totals. Maybe a pivot table???

rylo

I was trying to avoid having to have someone use a pivot table, but it looks like that is going to be the best bet.

Thank you for all of your time and help.
~BCR~