-
Merge tables on diferent workbooks
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????
Last edited by alonzo9mg; 03-01-2007 at 06:05 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.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
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!
-
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules