Hi All,
I am a newbie in Excel VBA programming. I have a simple question. I have two excel files. One having complete detail and the other having three columns which are similar to the first but are in a random order.
Now i have to compare the each row of all three columns with the other and populate the rest of the information by copying from one file to another.
This task seems to be simple. Could anyone please guide me in doing this? or please provide the code of how to do this?
If anyone can send any example likethis?
I have also attached the two files on which i am working. Now the first three columns of "template_new" file and "pdo1" file are same (ADDR,TAGNAME and TERM). What i want to do is to compare the first three columns and then to copy the rest of the columns from "template_new" file to pdo1 file. The "template_new" file has the VBA script behind it which is copying data from sheet 3 in it to sheet 1.
Could anyone please help me in doing the above task?
Regards,
mhs100
Bookmarks