Need to syncronize data from two worksheets, or combine data from different sources? xlCompare does this work in a seconds. All you need is to open workbooks you want to merge and select Merge command:
When you select Merge command, xlCompare does the following:
You don't get comparison results in this case. This command does all work itself and gives you result of merge operation on the left sheet.
So, data from the right book(worksheet) is merged into the data in the left book(worksheet).
On image below you can see typical results on the merge command:
See Also:
Get duplicate records from 2 lists