MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Merging 2 worksheets

Posted by Rich Baur on November 27, 2000 6:52 AM

I have one worksheet which contains part numbers, description of parts, and quantities(new, used, dmgd-w, dmgd-nw). Worksheet 2 will contain part numbers in a random order and quantities assocaited with each part number.

I want a macro to take the part number from ws2 and find it in ws1. Then I want the macro to enter the quantities from ws2 into ws1 with the corresponding part number.

How can I do this?

Posted by marbel on November 28, 2000 10:36 AM

My answer to everything is pivot tables. Try the multiple consolidation range feature.
Let me know if you hit any roadblocks.