PDA

View Full Version : Merge tables on diferent workbooks



alonzo9mg
03-01-2007, 05:25 PM
I need to merge 2 workbooks with simular data. Both books contain a "unique key" which is my customers ID numbers. But the books have different data for each ID number.
Ex
WB1
A B C
123 Marcus Gray

WB2
A B C
123 4widgets $25.00
Also, one book has ID numbers that the other does not have, so a simple copy and past will not do as I would have to do a search and find for hundreds of ID numbers to match them... Whew!! Help????

mdmackillop
03-01-2007, 05:38 PM
Hi Alonzo,
Welcome to VBAX.
Can you make up and post a small before and after sample. Use Manage Attachments in the Go Advanced section.

alonzo9mg
03-01-2007, 06:07 PM
I've added the attachment. Instead of multiple workbooks I just used the worksheets for examples... Let me know if I am making any sense!

mdmackillop
03-02-2007, 05:46 PM
No attachment