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
  • 676
  • $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
  • SSuite Accel Spreadsheet  v.8.44.2.1This powerful and professional free spreadsheet has all the tools you need to calculate, analyse, summarise, and present your data in numerical reports or colourful graphics. A fully-integrated help system makes entering complex formulas a breeze.
  • XLSTAT  v.2018.7XLSTAT is a complete data analysis and statistics add-in for Excel. It includes regression (linear, logistic, nonlinear), multivariate data analysis, parametric tests, non parametric tests, ANOVA, ANCOVA, forecasting methods.
  • ExcelPipe Find and Replace for Excel  v.7.8Batch Search and Replace multiple Excel spreadsheets. Change hyperlinks and UNC paths when servers get renamed, update names, addresses, phone numbers, data sources, translate with find/replace lists. Automatically handles passwords ...
  • DataNumen Excel Repair  v.2.3DataNumen Excel Repair is a powerful tool to repair corrupt Excel xls and xlsx files. It can scan the corrupt Excel files and recover your data in them as much as possible, so to minimize the loss in file corruption.
  • 3D Cars Show ScreenSaver  v.1.0This screensaver shows various high realistic 3d models of world famous cars. There are 5 models - BMW M3, Audi A4, Subaru Impreza, Lancia Integrale, Dodge Challenger. Each car slowly rotates on illuminated pedestal to let you see it from each side.
  • ASPNet Spell  v.2.42The AspNetSpell component provides an international spellcheck for your ASP.Net web forms. It includes familiar features such as Grammar & Personal Dictionaries. It looks and behaves like MS Word's Spellchecker. Compatible with ASP.Net 1.x & 2.0 ...