Merge Tables Wizard for Microsoft Excel 3.1.4
The add-in is an easy-to-understand alternative to Microsoft Excel Lookup and Vlookup functions. It perfectly merges matching data from two tables whether they are located in the same or in two different Microsoft Excel files.
The intuitive and smart wizard provides a step-by-step guidance through the join process while additional capabilities and advanced options of the add-in ensure exactly the results Excel users need. Those who do a lot of data analysis in Excel will definitely appreciate the following capabilities of the Merge Tables Wizard:
- Ability to find and copy matching data in seconds.
- Auto-detecting all matching columns.
- Using one or several columns as matching criteria.
- Comparing Excel lists from different workbooks.
- Adding new columns to the main table or updating values in existing columns.
- Highlighting updated data in any color.
- Updating only empty cells so that the existing content won`t get overwritten.
The add-in works in all versions of Microsoft Excel from 2003 to 2013 (32- and 64-bit).
Get started with a free download at http://ablebits.com/mergeexcel
IMPROVED: Excel color palette is used for picking new background color for the updated values.
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.
FIXED: Incorrect work in Windows XP and Windows Vista if data contain dashes or apostrophes.
FIXED: Error when selecting the "Update values in" action, a mathing column was not available.
on CD-ROM or on disks, provided that:
- the original files are not modified
- the program isn`t bundled with illegal or offensive material
Differing conditions need to be negotiated: mailto:email@example.com
...TOC is a table of contents generator...for a Microsoft Excel workbook. This Excel...create a new worksheet listing the names...the workbook. The worksheet names are also...hyperlinked to the worksheet to allow quick...TOC will only list the first ten...
...Worksheet search and activation...tool for Excel. Worksheet search integrates into...the Excel toolbar and adds...a quick worksheet search using sheet...help people using Excel workbooks with a...
...you build your excel worksheet you base...you run your worksheet you plug new...the results. My Excel Plug Numbers 1.0...is an Excel Add-In that let...By using My Excel Plug Numbers 1.0...externally to your worksheet and plug it...into any worksheet by using the...directly from any Excel in your local...
...of splitting multi-worksheet excel files into single-worksheet...sheets to separate Excel files. Excel Sheets...simplifying your tedious Excel Worksheets Separation work....Excel Sheets Separator can...divide an Excel file of multiple...into several new Excel files each containing...
...to migrate MS Excel data into MS...SQL databases. Each worksheet becomes a table,...versions of MS Excel are supported (2)...(3) merges MS Excel data into an...into MS SQL tables (5) command line...support (6) easy-to-use wizard style interface...