Merge Tables Wizard for Microsoft Excel - Combine matching data from 2 Excel worksheets into one in seconds.
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
What's New: ADDED: Microsoft Excel 2013 (32-bit and 64-bit) support. ADDED: The "Auto Detect" button on the "Select matching columns" step. When the button is pressed columns with the same name in Master and Lookup tables are selected automatically.
Limitations: 15 Days Trial
TAGS: excel, lookup, table, list, worksheet

Merge Tables Wizard for Microsoft Excel 3.0.2 is 100% clean
This download (merge-tables-excel.zip) was tested thoroughly and was found 100% clean. Click "Report Spyware" link on the top if you found this software contains any form of malware, including but not limited to: spyware, viruses, trojans and backdoors.

 

1. Ablebits.com Duplicate Remover for Excel 3.0.1 - Remove duplicates from a list, compare two tables for duplicates or uniques.
2. Ablebits.com Split Names for Excel 1.5.2 - Split a column of names into individual cells: names, salutations, suffixes etc.
3. AutoFormat for Excel PivotTables 2.0.3 - Create, store and apply your own formats for excel pivot tables
4. Advanced Find & Replace for Excel 4.5.4 - Find and Replace in values, formulas and comments in all opened workbooks.
5. Merge Cells Wizard for Excel 3.0.8 - Merge Excel cells preserving all data, join by rows or columns.
6. Ablebits.com Workbook Manager for Excel 1.0.4 - See all opened books & sheets in a tree view. Easily sort, insert, rename, copy
7. Fuzzy Duplicate Finder for Excel 3.5.3 - Find and remove partial duplicates, misprints and typos from Excel worksheets.
8. Consolidate Worksheets Wizard for Excel 1.0 - Combine data from several Excel worksheets into a single worksheet
9. Split Table Wizard for Microsoft Excel 1.0 - Split an Excel worksheet into separate tables by column value
10. Combine Rows Wizard for Microsoft Excel 1.0.1 - Combine data from multiple duplicate rows into one in Excel 2010-2003.