has several commands which compare spreadsheets. But in this article we'll describe only one of them -
Compare Excel Workbooks
You can find it in the Compare | Books menu in xlCompare.
What is the difference between this command and another comparison commands? The answer is quite simple - This command performs complete
workbook comparison. When other commands are specific and may compare 2 worksheets or 2 visual basic modules, this one compares everything in the books.
It goes through worksheets, names, charts, tables and VBA Projects and looks for a differences. All found descrepancies are shown in the Difference Browser
window. This is handy and easy to use navigation tool which gives you ability to explore all discrepancies and execute merge commands.