Excel Training, Excel VBA Training, Excel Software Design

Table Compare for Microsoft Excel


Table Compare for Microsoft Excel

Microsoft Excel Add-In Version 9.0

Compare different worksheet tables and output the results.

About Table Compare

For: Excel versions 2007 and above; Windows 7.0 and above

A common Microsoft Excel task to perform in the workplace today is to compare two worksheet tables to see what is different. Our Table Compare Microsoft Excel Add-In does just that allowing you to rapidly compare data in two Microsoft Excel worksheet tables. The worksheet tables being compared can be of any size, on the same worksheet, on separate worksheets or in separate workbooks. Using our table compare the following tasks can be performed:

  1. Search for missing records between two separate tables. Once found, the data can be extracted by record and/or can also be flagged
  2. Search for new records between two separate tables. Once found, the data can be extracted by record and/or can also be flagged
  3. Find duplicate records within a table flagging the duplicate data and/or extracting the non-duplicate data to create a new table
  4. Match table records and copy and paste the data from one table to another
  5. Do a comparison between one, two or three columns in separate tables and return a result of the comparison

Table Compare uses our active cell technology. This means you can launch Table Compare, leave it open and maneuver around in Microsoft Excel without closing it. Table Compare is viewed as a floating dialog box, not a Ribbon tab, which means it follows you around the screen and avoids the annoying Ribbon trip to activate its features. Table Compare is also smart and allows you to save multiple tool configurations allowing you to rapidly reconfigure the tool based upon the worksheet tables that you are currently working with. 

At EMAGENIT, we are always looking to improve our add-ins so if you have a particular capability you would like to see added to Table Compare, click on our suggestion link and let us know. Make a suggestion.

Available: Coming in February



Site Map

Copyright © 2002-2017

EMAGENIT All Rights Reserved