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