Merge Tables Wizard for Microsoft Excel

This handy add-in quickly looks up and copies matching data from one Excel table to another. Two tables can be located in the same or two different Excel files. You can use one or several columns as matching criteria. Works for Excel 2007 - 2000.

Pros: The plug-in merges with the excel controls very well. Choosing the range of rows or columns or other controls works as with the main Excel sheet.

The controls related to the plug-in appear as an additional button on the tool bar of Excel. First step is to select the master table or the table where the second table is to be merged through the wizard that appears. The second table could be in the same sheet or even a different one. The range of rows/columns are chosen the same way one would have picked these data ranges while creating a chart from the Excel data table. Several rows or columns can be used as the matching criteria.

Changed data can be highlighted with color to facilitate error checking or highlight important changes. Update/ non updated columns can be filtered for rapid viewing.

Cons: Nothing adverse was noticed, just works as expected.

Overall: Adds very limited functionality but works well. So deserves a 5 star rating.

With this handy plug-in you can easily combine data from different sources. The add-in quickly lookups and merges matching data from 2 tables that can be located in the same or in two different Microsoft Excel files. The intuitive and smart wizard guides you through the merge process. Rows from two tables with different number of columns will be matched perfectly without copying and pasting!
With this handy plug-in you can:
- Find and merge matching data in seconds.
- Use one or several columns as matching criteria.
- Compare Microsoft Excel lists from different workbooks.
- Add new columns to the main table or update values in the existing columns.
- Highlight the updated data in any color.
- Update only empty cells in your master table if you don't want to overwrite the existing values.

The add-in works for Excel 2010 32-bit and 64-bit, Excel 2007, Excel 2003.
Watch the video to see how it really works: http://www.ablebits.com/go.php?to=mtwvideo-s