Macro to compare rows in 2 files where ID is the same

L

*lolita*

Joined
Mar 28, 2012
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

in an Excel database, comparaison between two columns with "almost"the same names => how to search i 1
Compare two lists 5
Access Compare records in same access table 0
Locating differences in text when comparing two cells 10
Macro to add Multiple rows in same sheet 1
Macro for comparing columns and highlighting matching/differences 14
Copy compare worksheets 1
Copy certain rows to new worksheet 1

Top