Merge Tables Wizard for Microsoft Excel Icon

Merge Tables Wizard for Microsoft Excel

Lookup and copy matching data from one Excel worksheet to another.

Merge Tables Wizard for Microsoft ExcelOverview

Just imagine this: you have two Microsoft Excel worksheets with common columns e.g. personal number or name. You want to merge them into one, or update information in your main Spreadsheet. If you decide to do it manually, you will have to go through each row in the main spreadsheet to identify the matching row on the second spreadsheet. After that you will spend even more time on updating selected rows sourced from the second spreadsheet, or on adding some columns from the lookup table to the main list.

Our Merge Tables Wizard for Microsoft Excel makes finding and copying matching data in Excel worksheets a breeze. This handy vlookup add-in quickly merges two Microsoft Excel tables into one by matching values in corresponding columns.

The two tables can be located in the same Microsoft Excel file or in two different Excel files. The intuitive and easy-to-understand wizard will guide you through the merge process. Rows from the two tables with different number of columns will be matched perfectly without copying and pasting.

With Merge Tables Wizard for Microsoft Excel you can

* Find and merge matching data in 2 tables in seconds following 5 easy Steps of The Wizard.
* Use one or several columns as matching criteria.
* Compare Excel lists from different workbooks.
* Add new columns to the main table or update data in existing columns.
* Add non-matched rows to the end of the table after all other data.
* Highlight updated data in any color.
* Add a Status column to the Master table that will reflect changes and mark rows as: "Updated", "Non-updated", "New row".
* 100% support of Microsoft Excel 2007: Ribbon interface, one million of rows and so on.

NEW

Fixed some bugs.

Merge Tables Wizard for Microsoft ExcelInformation

Version
2.0.3.307
Date
10.15.10
License
Trial
Language
English
File Size
2.55MB
Category
SubCategory
Operating Systems
Windows 7, Vista, 2003, XP
System Requirements
No additional system requirements.

Merge Tables Wizard for Microsoft ExcelPrevious Versions

Duplicate Remover for Microsoft Excel Icon
Remove duplicates from a list, compare two lists for duplicates or uniques.
Trial
ADX Toys for Microsoft Excel Icon
Is a free sample COM add-in that extends Microsoft Excel.
Free
Outlook Security Manager Icon
Allow you to bypass security settings and avoid security warnings in add-ins.
Paid
Add-in Express 2008 for Office and VSTO Icon
Visual component set to develop professional Office extensions in VSTO
Trial
EldoS AutoSaveXL Icon
Automatically saves backup copies of Excel files while you are working with them
Trial
More
Excell Icon
Manage your data by using CSV files
Free
Microsoft Excel Viewer 2003 Icon
open, view, and print Excel workbooks, even if you have example excel formula.
Free
School Timetable Framing Software Icon
GIFT School Timetable is powerful and complete timetabling software
Trial
Kutools for Excel Icon
Bring more than 120 advanced functions to Excel.
Demo
Excel File Size Reduce Software Icon
Shrink (trim, decrease, compress) filesize of big Excel spreadsheets.
Trial
Material Requirement Planning Spreadsheet Icon
Material requirement planning Spreadsheet templete
Trial
Unit Converter for Excel Icon
Microsoft Excel addin to perform various conversions of measurement units.
Trial
QI Macros SPC Software for Excel Icon
Create SPC charts and Six Sigma projects in Microsoft Excel.
Demo
More