PDA

View Full Version : Solved: Merge Data between worksheet



tlchan
08-01-2008, 08:50 AM
I wish to merge the data between 2 worksheets based on account No in "New" worksheet. Data to be merged is from CSDS field under worksheet "Old" to CSDS field in "New" worksheet. Two worksheets are of different data size and account No is not in the same order.

Is there any VBA to enable to perform this task? There are about 7,000 data to be merged between "old" and "New" worksheet.
:dunno
Assistance is greatly appreciated


Attached my sample workbook.

Bob Phillips
08-01-2008, 08:56 AM
Just add a formula in New!D2 of =VLOOKUP(B2,Old!B:D,3,FALSE), and copy down.

mdmackillop
08-01-2008, 10:44 AM
Unless you need the link to be dynamic, it may be better to Copy/PasteSpecial Values the results from XLD's code otherwise you may find changes slow down your workbook.

tlchan
08-01-2008, 04:39 PM
It works perfect and exactly what I'm looking for.Thanks XLD & MD for the solution.

:hi: