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)|
MailConverterTools EML to NSF Converter 3 hours ago
Soda PDF 4 hours ago
RationalPlan Single Project for Mac 4 hours ago
Increase or Decrease Speed Of Multiple MP4 Video Files Software 4 hours ago
ShoreWAVConv 5 hours ago
Macsome 6 hours ago
id cards 8 hours ago
Convert MBOX to PDF Software 8 hours ago
DataNumen Excel Repair 12 hours ago
Power Spy 109 times
Antamedia HotSpot Software 109 times
Dwyco VideoChat Community 107 times
Advanced ETL Processor 104 times
Time and attendance 89 times
VyprVPN for Mac 88 times
Power Spy Keylogger 83 times
OST to PST Converter 81 times
ACDSee 79 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.