Spreadsheet Tools - Add-ins and applications for Microsoft® Excel®

 xlCompare compares 2 workbooks\sheets\ranges. One of them is considered as older version of a document, and another one - as newver version. Before data will be compared, you should specify where is older data, and where is newer.

 xlCompare is present on the Excel 2007/2010 ribbon in the Compare and Merge tab. In Excel 2003 xlCompare is represented by a menu Compare.

Excel 2007/2010:

Excel 2000/XP/2003:

In Excel 2000/XP/2003 xlCompare adds toolbar in addition to menu:

Each item represents a command:

• Recent Items(Recent Comparisons) - list of last comprisons. xlCompare remembers 4 last comparisons and you can repeat them without opening workbooks and selecting data. xlCompare opens needed files and makes comparison.
• Compare Workbooks
• Compare Worksheets
• Compare Ranges
• Activate this copy of xlCompare
• Show xlCompare Help Library - displays contents of this help library.

As a result of each comparison command you get list of differences. Topic Working with comparison results describes how to work with this data.

You can use xlCompare in your VBA macro. Check topic Use xlCompare functions in the VBA code to find descriptions and examples of the macros.

Merging values is described in the How to merge workbooks topic.