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.
mb
