Recent searches
duplicates, Excel worksheet, free software, tables (6 related words found), PayPal, chart, Excel, rows, downloads, Microsoft Corporation, Excel spreadsheets, user-friendly interface, table, Tables, tables, Free Trial, Excel files, values, two tables, Merge, table's, Wizard, chart's, rates, MS Excel, Excel add-in, for, Wizard add-in, Microsoft

Merge Tables Wizard for Microsoft Excel 1.67 (Trial)

Other Office Tools / Merge Tables Wizard for Microsoft Excel 1.67 (Trial)
Merge Tables Wizard for Microsoft Excel 1.67 (Trial)
Merge Tables Wizard for Microsoft Excel 1.67 (Trial)
Developer: Add-in Express Ltd
License: Trial
Size: 2.04 MB
Added: 09 July 2008
Rating:
Rated by: 0 user(s)
Download
Downloaded: 0, viewed: 60
Merge Tables Wizard for Microsoft Excel 1.67 (Trial) Description
 
Merge Tables Wizard for Microsoft Excel 1.67 (Trial)
Merge Tables Wizard for Microsoft Excel 1.67 (Trial)
You have two separate Microsoft Excel worksheets with common columns e.g. personal number or name.

You need to go through each row in the Main (master) spreadsheet, identify the matching row (by index fields) on the second spreadsheet and update in the main spreadsheet selected fields sourced from the second (lookup) spreadsheet, or add some columns from the second list to the main list.

For example, suppose you have 2 Microsoft Excel tables (lists) - "Orders" and "Prices", they both have a column "Product ID".

You want to add a correct price and product description from the second table (lookup table) to you main table.

The task sounds too complicated and task consuming? Probably yes, if you try to do it with standard Microsoft Excel"s Match, Lookup, or Vlookup. But definitely not, if you have the Merge Tables Wizard for Microsoft Excel.

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

The two tables can be located in the same Microsoft Excel file or two different Microsoft Excel files. The intuitive and user-friendly interface of the wizard makes the join process fast and easy.

The rows from two tables with different number of columns can be matched perfectly without any copying and pasting.

Here are some key features of "Merge Tables Wizard for Microsoft Excel":

· 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 data in existing columns.
· Highlight updated data in color.
· Filter updated or non-updated columns.


Requirements:

· Microsoft Excel 2000


Limitations:

· 15 days trial

Download