Compare records from two excel files and Copy one column from one file to other.

We have two files. File1 and File2 with different contents and records are not aligned.

File1 has many columns. Primary identifier are three columns A,B and C. Additionally column D has the data that needs to be copied to File2.
File2 will also have the same three columns.

Code:
In both the files the records are not in same order.
We need to take first record(coulm A B and C) from file1 match it with the available records from File2. Then update(copy & paste) the column D from file1 to Column D of File2.

This needs to be done for all the records in File1.

Records are nothing but rows.

Thanks,
Balaji N

Originally Posted by vichopalacios

@ balajinatarajan

If File1 and File2 are sheets in the same book,
you can try this code

Please Login or Register  to view this content.

Thanks. It works with charm.