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????
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????