Merge Tables Wizard for Microsoft Excel 3.0.2
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
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:info@ablebits.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...