Add Quantity of Redundant Rows, then Delete Redundant Rows

Hi All!

I'm trying to combine multiple lists of things people want (such as multiple grocery lists of items and their quantities). I'd like to create a vba code that sorts the lists from A-Z (to get the redundant items next to one another), add the quantities of the items, then delete the redundant rows.

For example:

Person A wants:

Item	QTY
Apple	2
Bananas	2
Oranges	2

Person B wants:

Item	QTY
Apple	1
Bananas	3
Oranges	1
Pineapples	2

And want my list to end up like this:

Item	QTY
Apple	3
Bananas	5
Oranges	3
Pineapples	2

Noting that the order may not always be alphabetical and the number or type of items they want may not be the same either.

If there's a more succinct way of accomplishing my same goal I'm all ears! I appreciate all your guys' help in advance! Thanks!

Hi Alex,

If you have a master list of the products, then this can easily be created - using formula or VBA where the quantities will show up against each product based on the preference of various person(s). If you want VBA solution, then you need to specifiy which sheet / range contains these individual list and where do you want the master list to be compiled and housed. I believe little home work is what you need to do here.

If possible, upload a sample workbook.

Cheers

Regards,
DILIPandey

<click on below 'star' if this helps>

Hi Alex,

See the attached file with required macro to solve your purpose.

Let me know if this helps.

Regards,
DILIPandey

<click on below 'star' if this helps>

You are welcome Alex... !!

Cheers

Regards,
DILIPandey

<click on below 'star' if this helps>