Using xlCompare to compare Excel Workbooks.
When your workbooks are opened, you need to select appropriate button
on the xlCompare ribbon
On the next step select names of the workbooks to be compared, and press Compare button:
In a few seconds you will receive comparison report!