How i can compare two excel files 2007 via macro? Help

Question

Hello, Please help me its emergency, i am looking for a macro code to compare two excel files if the data matches it should copy the info from one file to another new file.

The comparision is like for eg: A Column (Name) and B Column( ID) in one sheet matches with the A column(EName) and B Column(EId) then it should take the entire row from the second file and paste it another new excel file and save it and if there is a new row in the second file that doesnt exist in the old file copy the entire row and paste it in the new file. Also, it would be nice if the differences would be highlighted in a different color whether the line only occurs in the first file or in the second file. hope some one will help me :(

Answer 1

Basically you need to compare the values of that cells. It's not very hard, but if you don't have any experience it will take some time. You can start with this basic tutorial.