2,405 downloads Updated: Oct 5th, 2018 Trial   
  n/a

Review

download

specifications

changelog

  Images

  100% CLEAN   report malware

Consolidate Worksheets Wizard for Excel icon Combine data from several Excel files into a single worksheet with the help of this easy to use and intuitive Microsoft Excel add-in

Consolidate Worksheets Wizard for Excel is an easy to use software solution designed to help users merge multiple spreadsheet documents.

Consolidate or merge tables without having to copy and paste data

This software comes as an add-in for Microsoft Excel, is easy to install, and does not need to be configured. Once the setup process is complete, users can access it from its dedicated tab.

It aims to help users automate the time-consuming and tedious task of manually merging and consolidating tables by providing them with an easy to follow, five step wizard that does away with the need to copy and paste data from one table to the other.

The wizard enables users to select between five automated methods of consolidating tables.

Save time by making use of this add-in's powerful features

After users have launched the wizard, they can select which data ranges to use. This can be accomplished either by manually typing the ranges in, or selecting them from a worksheet. The wizard enables users to add multiple files, each containing multiple worksheets. Data can be selected from each of these worksheets.

The next step is selecting the method used to consolidate the data. Data can be combined and copied using one of five available methods, each of them being further customizable during the third step of the wizard.

Data can be copied from multiple ranges into a single worksheet, multiple worksheets can be combined into a single workbook, or data ranges can be combined based on their headers and contents.

Some of these methods enable users to further process the data by applying mathematical or other functions to it. This is a very handy feature that can be used to automatically, update stocks or calculate attendance, for example.

Conclusion

This is an easy to use and powerful software solution that can help users easily manage multiple Microsoft Excel documents by providing them with a means of combining or merging data.

Merge Worksheets Consolidate Worksheet Combine spreadsheets Merge Combine Join Consolidate

Consolidate Worksheets Wizard for Excel was reviewed by Corneliu Paval
4.5/5
  Click to load comments
This enables Disqus, Inc. to process some of your data. Disqus privacy policy

Consolidate Worksheets Wizard for Excel 2018.3.103.7510

add to watchlist send us an update
  file size:
5.7 MB
  runs on:
Windows 10 32/64 bit
Windows Server 2012
Windows 2008
Windows 2003
Windows 8 32/64 bit
Windows 7 32/64 bit
Windows Vista 32/64 bit
Windows XP
  main category:
Office tools
  10 screenshots:
  developer:
Add-in Express Ltd.
  visit homepage