Hi All,
I am having a problem and I really would appreciate the help.
I have two different files with more than thousand rows.
the first one is the original and the second one is the updated one. I want a macro that will compare the rows in the two files where first it will check the ID in the first cell in the row look for that ID in the second file and compare the two rows and if there is any changes then it will write the ID in a different sheet in the updated file.
Please help X__X
I am having a problem and I really would appreciate the help.
I have two different files with more than thousand rows.
the first one is the original and the second one is the updated one. I want a macro that will compare the rows in the two files where first it will check the ID in the first cell in the row look for that ID in the second file and compare the two rows and if there is any changes then it will write the ID in a different sheet in the updated file.
Please help X__X