Advanced Consolidation Manager Icon

Advanced Consolidation Manager

Add-on for advanced table merging and data consolidating in MS Excel 2000-2007.

Advanced Consolidation ManagerOverview

Editor: Advanced Consolidation Manager is designed for merging tables and consolidating Microsoft Excel data. In comparison to a standard data consolidation in Microsoft Excel, Advanced Consolidation Manager will allow you to process any number of files per one program run as well as to combine data from different files in one.

Advanced Consolidation Manager will help you to consolidate data from different files in one:

* with grouping by worksheets;
* by creation of a new worksheet for each file;
* by creation of one common table;
* with the performance of calculation: summation, calculation of quantity, calculation of average value, etc.

Consolidation of data from several files

If you have a number of Similar files or you regularly get reports in Microsoft Excel files and you need to consolidate them, Advanced Consolidation Manager can easily solve these tasks. Specify which files and their worksheets to be combined and the location where the results are to be stored – Advanced Consolidation Manager will perform these tasks. The program stores the results either in a common worksheet or in several ones. There is also a possibility to group worksheets in different Microsoft Excel files.

In contrast to a standard data consolidation in Microsoft Excel, Advanced Consolidation Manager will enable you to perform the above mentioned operations on the unlimited number of files. Moreover, if files have a similar structure, you can specify a common range which will be applied to all these files. In other words, you can specify one a range of cells which is to be used for consolidation and this range will be used for all selected worksheets.

If you often use a standard data consolidation in Microsoft Excel, you will find the program Advanced Consolidation Manager of a great help.

NEW

Fixed some bugs.

Advanced Consolidation ManagerInformation

Version
1.1.1
Date
03.21.10
License
Trial
Language
English
File Size
3.52MB
Category
SubCategory
Operating Systems
Windows 7, Vista, 2003, XP, 2000, 98
System Requirements
No additional system requirements.
Compare Spreadsheets for Excel Icon
A powerful and convenient add-on for comparison of MS Excel 2000-2007 files.
Trial
Tables Transformer for Excel Icon
This is a fast and easy way for Microsoft Excel 2000-2007 tables transformation.
Trial
Similar Data Finder for Excel Icon
This add-on helps you to find cells with similar values in Excel worksheets.
Trial
Fix Broken Link for Excel Icon
MS Excel add-on helps you to find and fix broken links in Excel linked files.
Trial
MAPILab Find and Replace Icon
MAPILab Find and Replace for Excel is an advanced and extended version.
Trial
Remove Duplicates from Excel Icon
Searching and processing duplicated cells in Microsoft Excel tables.
Trial
<b>Tables Transformer</b> for Excel Icon
This is a fast and easy way for Microsoft Excel 2000-2010 tables transformation.
Trial
<b>Similar Data Finder</b> for Excel Icon
This add-on helps you to find cells with similar values in Excel worksheets.
Trial
More
Excell Icon
Manage your data by using CSV files
Free
Microsoft Excel Viewer 2003 Icon
open, view, and print Excel workbooks, even if you have example excel formula.
Free
School Timetable Framing Software Icon
GIFT School Timetable is powerful and complete timetabling software
Trial
Kutools for Excel Icon
Bring more than 120 advanced functions to Excel.
Demo
Excel File Size Reduce Software Icon
Shrink (trim, decrease, compress) filesize of big Excel spreadsheets.
Trial
Material Requirement Planning Spreadsheet Icon
Material requirement planning Spreadsheet templete
Trial
Unit Converter for Excel Icon
Microsoft Excel addin to perform various conversions of measurement units.
Trial
QI Macros SPC Software for Excel Icon
Create SPC charts and Six Sigma projects in Microsoft Excel.
Demo
More