Merge Tables Wizard for Microsoft Excel v.3.1.4

Advertisement
Advertisement

With Ablebits.com Merge Tables Wizard you can lookup and combine matching data from 2 Excel worksheets in seconds.
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

Match and combine Excel spreadsheets. 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.

excel, lookup, marge, table, list, worksheet

 
  • Merge Tables Wizard for Microsoft Excel
  • 3.1.4
  • 26 Jun 13
  • Add-in Express Ltd.
  • WinXP, WinVista x64, Win7 x32, Win7 x64, Win2000, Windows2000, Windows2003, WinServer, Windows Vista
  •  
  • Shareware
  • 14.81 Mb
  • 557
  • $49.95
 
 
Latest Versions History
Version Date Released Release Notes
3.0.2 21.01.2013 ADDED: Microsoft Excel 2013 (32-bit and 64-bit) support. 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.
 
 

Review Merge Tables Wizard for Microsoft Excel

  • captcha
 

Other software of Add-in Express Ltd.
  • Ablebits.com Addins Collection for Excel  v.2012.212 time-saving add-ins for Excel 3003 - 2010 will help you with the most common tasks such as removing duplicates, merging tables and cells, generating random numbers, clearing data, finding and replacing in all workbooks, splitting names etc.
  • Ablebits.com Duplicate Remover for Excel  v.3.1.5Find and remove duplicates in Microsoft Excel 2013, 2010, 2007, 2003 tables. Search for duplicates in one table or compare two worksheets with different number of columns, choose any columns for comparison.

New Spreadsheets software
  • ExcelPipe Find and Replace for Excel  v.7.6Batch Search and Replace multiple Excel spreadsheets. Change hyperlinks and UNC paths when servers get renamed, update names, addresses and phone numbers, translate with find/replace lists. Automatically handles passwords. Unicode compliant ...
  • QR-Code Native Excel Barcode Generator  v.17.07The Native QR-Code Barcode Generator for Microsoft Excel provides barcoding capability to Microsoft Excel Spreadsheets with an embedded VBA macro making it easy to share sheets without needing to distribute additional fonts or other components.
  • Dose for Excel  v.3.2.8Dose for Excel is a powerful, feature-rich add-in for Microsoft Excel, which allows you to quickly perform functions that would otherwise take up much time.