Download Ablebits.com Merge Tables Wizard for Microsoft Excel
Over 28,629 Win x64 downloads! Bookmark Now!

Windows 64 bit Software - the latest is here right now! But that's not all. We update our collections every single minute -

Home > >


Ablebits.com Merge Tables Wizard for Microsoft Excel  

Ablebits.com Merge Tables Wizard for Microsoft Excel 4.x Windows NextStep

    Platform: WinXP,Windows Server 2003,Windows Server 2003 x64,Windows Vista,Windows Server 2008,Windows Vista x64,Windows 7,Windows 7 x32,Windows 7 x64,Windows Server 2008 R2,Windows 8,Windows server 2012,Windows 8.1,Windows 8 x32,Windows 8 x64,NextStepWin95
Download Ablebits.com Merge Tables Wizard for Microsoft Excel Now
  Buy Now     
Size: 1 MB $ 49.95  

Merge Tables Wizard for Excel add-in lets you update your main table with the records from another worksheet. It perfectly matches and merges data from 2 Excel lists in seconds.

  • Update columns in your main table or add new columns from the lookup list
  • Add non-matching rows to the end of your master table
  • Paste additional matches from the lookup table
  • Match by one or more key columns
  • Mark the changes in the Status column or color the updated cells

Merge 2 tables in seconds

If you have 2 Excel worksheets that contain 1 or several matching columns, you can compare them to find and pull the updates to your main sheet. It's also possible to add columns or rows that are not present in your main table. In addition, the two worksheets you match can be located in the same Excel file or in two different workbooks.

Suppose you have 2 sheets. One of them contains product names and prices. The other has products, prices and stores. You can compare the lists using the Product column as key to refresh your main table with the updated prices. If necessary, you can choose to add the stores according to the records in the matching Product column.

Merge Excel spreadsheets by matching data

Add non-matching rows to the end of your main table

You can easily copy additional rows that are not present in the master table. For example, both tables contain a column with IDs. Table A includes the IDs from 1 to 15. Table B has IDs from 1 to 20. Thus, the numbers from 16 to 20 in your second table don't coincide. When you select the Add non-matching rows to the end of the master table option, the lines with such values will be inserted after all rows in the corresponding columns of the first table.

Paste additional matches from the lookup table

When several people work with the same spreadsheets, there can occur duplicate values on different rows that contain unique information. To keep all records, you can add such rows to your main table by picking the option Paste additional matches from the lookup table.

You can choose to paste additional matches at the end of the main table or add duplicate rows after the same key value of the first table.

Additional options for matching and merging data

To ensure that you get the expected results, the Merge Tables Wizard tool suggests a number of really helpful options.

  • Merge data from the same or 2 different workbooks.
  • Automatically select the columns to update and those to add to the end.
  • Mark the updated rows in the Status column as: matching, matching and updated, or new row.
  • Choose any color to apply it to the updated cells.
  • Update only empty cells in your main table if you don't want to overwrite the existing records.
  • Update only if cells from lookup table contain data.

Using this intuitive and smart 5-step wizard, a difficult and time-consuming task can be performed quickly, easily and without errors.

Feel free to download and install the fully-functional trial version of Merge Tables Wizard to see how it works.


Click to view Ablebits.com Merge Tables Wizard for Microsoft Excel screenshots
Click to Enlarge
Publisher: Add-in Express Ltd. | More by Add-in Express Ltd. | Visit Home Page
Downloads: so far this month, 0 last month, 0 total
License: Shareware $ 49.95
Last updated: 11 months ago (29 Jan 16)
Install support:
Watch for updates:
Want to be notified when Ablebits.com Merge Tables Wizard for Microsoft Excel is updated?
(no spam, just a single confirmation email)
Subscribe

Tell a friend... | Add to My CD | What's on My CD
User Rating: NOT RATED
Rated by: 0 user(s)
3 out of 5 stars
User 0/5 stars User 0/5 stars User 0/5 stars User 0/5 stars User 0/5 stars  
Ask a question about Ablebits.com Merge Tables Wizard for Microsoft Excel

Add this link to your website:

Or to a forum:


ExcelPipe Lite (+1 Yr Maintenance) - Automatically Find and Replace across Thousands of Microsoft Excel spreadsheets. Change hyperlinks and UNC paths when servers get renamed; update contact details such as names, addresses and phone numbers; translate... ...
SF Pressure Drop 7.x for Windows buy, download and review

SF Pressure Drop 7.x for Windows

<!-- h1.gross { color : blue; font-size : x-large; font-family : Arial;...

Shareware | $ 58.04
PDFing Interactive (131002) Screen shot

PDFing Interactive (131002)

NEED iSeries/AS400 REPORTS IN PDF? PDFing can e-mail them to your users! PDFing will e-mail OS400 spooled-files...

Shareware | $ 399.00
AbleBits.com Advanced Find & Replace for Microsoft Excel Screen shot

AbleBits.com Advanced Find & Replace for Microsoft Excel

Advanced Find &amp; Replace for Microsoft Excel is a time-saving add-in that makes search through multiple...

Shareware | $ 29.95
AbleBits.com Add-ins Collection for Microsoft Excel buy, download and review

AbleBits.com Add-ins Collection for Microsoft Excel

The Add-ins Collection for Microsoft Excel includes 12 add-ins that were specially designed to deal with the most...

Shareware | $ 119.80
Ablebits.com Duplicate Remover for Excel Screen shot

Ablebits.com Duplicate Remover for Excel

With Ablebits.com Duplicate Remover for Excel you can easily remove duplicates from your Excel tables or find unique...

Shareware | $ 29.95
Merge Tables Wizard for Microsoft Excel Screen shot

Merge Tables Wizard for Microsoft Excel

With Ablebits.com Merge Tables Wizard you can lookup and combine matching data from 2 Excel worksheets in seconds....

Shareware | $ 49.95
Oxygen Phone Manager II for Symbian OS phones Screen shot

Oxygen Phone Manager II for Symbian OS phones

Oxygen Phone Manager II for Symbian OS smartphones lets your PC and mobile Symbian OS phone communicate with each...

Demo | $ 46.00
AutoCAD to Excel - TableBuilder Screen shot

AutoCAD to Excel - TableBuilder

TableBuilder is designed to export AutoCAD table and the table drawn with lines and text in AutoCAD/MicroStation to...

Shareware | $ 99.00