Hello. I am in desparate need of a formula or VBA or MACRO for my problem. I have a about 5 spreadsheets of 3,000+ entries. All only have 2 columns, A & B. Column A has the model numbers and Column B has the quantity. There are many duplicates of different entries in Column A and I need to add up their quantities and make it into 1 row.
Example:
A B
Model Number Quantity
1234 2
4321 1
1234 2
4321 1


A B
Model Number Quantity
1234 4
4321 2


I cannot use a pivot table. Please help with this! Thank you!!