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.
xlCompare 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, contact us and you'll get in the next update for FREE.