Using xlCompare to compare Excel Worksheets.
xlCompare is a flexible and feature rich utility, that compares Excel worksheets and finds
differences in the formulas, cell values, cell formatting, defined names and VBA modules. This
tools performs complere comparison of the Excel Worksheets.
To start worksheet comparison you need to select Compare Worksheets command on the Excel ribbon.
In the Excel 2000, 2002, 2003 there is a menu Compare which has Worksheets command.
You can select 2 sheets from different workbooks of 2 worksheets of the same file. If worksheet
you need to compare is not opened, you can open it by clicking on the [...] button.
When selected worksheets are processed by xlCompare, you receive comparison report like this:
As you see, xlCompare doesn't require to select comparison options from you. It compares excel worksheets
in a single click. You should not sort data or align rows and columns. xlCompare processes all types
of workbooks: complex spreadsheet models, database tables, excel-addins.
Usage of xlCompare is more wide than usual excel worksheet comparison. You can do what-if analysis by
comparing 2 copies of your worksheets, version control management, merge database tables (price lists, customer
databases, accounting statements) and more.
is an ultimate tool for excel worksheet comparison.
You can use it to solve all excel comparison and merging tasks you encounter on the daily basis.
In the another articles you can find more information about what-if analysis, version control
management and VBA Project comparison.
If you don't see a feature you need in the xlCompare
us and you'll get in the next update for FREE.