Merge Tables Wizard for Microsoft Excel 3.1.4
This smart add-in can match and merge two worksheets in Excel 2013-2003 in seconds. You can use one or several columns as the unique identifier, update existing columns in the master worksheet or add new from the lookup table.
item has less then 1 vote
|OS Support||Windows Install and Uninstall|
|File Size||14.81 MB ( 15,163 KB )|
|Published||Apr 03, 2007 (14 years ago)|
|Updated||Dec 14, 2013 (7 years ago)|
Windows 10 Codec Pack 4 hours ago
Internet Cafe Software 5 hours ago
Enterprise Cloud WiFi 6 hours ago
Antamedia HotSpot Software 7 hours ago
VB.Net PDF 10 hours ago
C# HTML to PDF 10 hours ago
Prime ID Scanner 10 hours ago
Advanced Data Generator 10 hours ago
Guiffy eXpert Windows 11 hours ago
Antamedia HotSpot Software 142 times
VyprVPN for Mac 131 times
ACDSee 128 times
Photovoltaic System 124 times
Dwyco VideoChat Community 124 times
nanoCAD Plus 124 times
Database Workbench Pro 122 times
Advanced ETL Processor 122 times
Power Spy 120 times
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
|Requirements:||Microsoft Excel 2013 (32- and 64-bit), 2010 (32- and 64-bit), 2007, 2003|
|Release Info:||Major Update on Jun 26, 2013|
|Release Notes:||FIXED: Data outside of Excel table were included in the selected range. IMPROVED: Excel color palette is used for picking new background color for the updated values.|
|Related Tags:||excel lookup marge table list|
Reviews of Merge Tables Wizard for Microsoft Excel 3.1.4You can be the first to write a review of Merge Tables Wizard for Microsoft Excel!
Easily develop professional extensions for Microsoft Office. Build Office add-ins with minimal coding and debugging, customize Office 2007 Ribbon UI and Office 2003 toolbars with special visual designers in your VSTO 2005 (SE) and VSTO 2008 projects.Add-in Express 2008 for Outlook Express
Visual RAD toolkit for developing secure, managed, isolated, version-neutral plugins for Outlook Express and Windows Mail. Extend the Outlook Express GUI, create toolbars and menus, add custom menu items and controls, embed forms into OE windows.Add-in Express for Internet Explorer
All-in-one framework that provides a simple and quick way to customize Internet Explorer with your own browser extensions. You can extend the IE 6, 7 and 8 (32- and 64-bit) with menu items, toolbar buttons, context menus, toolbars and side-bars.Add-in Express for Office and .NET
All-in-one platform for developing any types of Office extensibility projects with minimal coding. Use visual designers to create powerful plug-ins for MS Office 2010 - 2000, smart tags, RTD servers and Excel UDFs in C#, VB.NET, C++ and Delphi Prism.Add-in Express for Office and VCL
A true RAD tool for writing COM Add-ins, Smart Tags and RTD servers in Delphi 5 - 2010. You write the code once and your extension works in all Office versions from 2000 to 2010 (32-bit). Supports Outlook, Excel, Word, PowerPoint, FrontPage, etc.