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 (13 years ago)|
|Updated||Dec 14, 2013 (6 years ago)|
Prism Video Converter Free for Mac 28 minutes ago
BackUp Maker 2 hours ago
Import MBOX files into Microsoft Outlook PST 4 hours ago
Image Date Time File name Stamp 4 hours ago
Office 365 Backup 4 hours ago
VideoProc 5 hours ago
Bandicam Screen Reorder 5 hours ago
CD Label Designer 5 hours ago
How to Move IncrediMail to PST 5 hours ago
Antamedia HotSpot Software 123 times
Power Spy 118 times
Advanced ETL Processor 116 times
Dwyco VideoChat Community 113 times
VyprVPN for Mac 103 times
System Mechanic Free 100 times
ACDSee 94 times
nanoCAD Plus 92 times
hide.me VPN for Windows 91 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.