Advanced Consolidation Manager 1.1.1
Add-on for advanced table merging and data consolidating in MS Excel 2000-2010. 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.
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. For example:
Advanced Consolidation Manager similar to a standard function of data consolidation in Microsoft Excel can consolidate data with the performance of the following calculations:
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.
|Requirements:||Microsoft .NET Framework version 2.0, Microsoft Excel 2000/XP/2003/2007/2010|
|Release Info:||Major Update on Mar 09, 2010|
|Release Notes:||Support for Microsoft Excel 2010 Beta has been added.|
|Related Tags:||excel xls consolidate worksheets excel add-in merge workbooks|
The add-on is designed for searching and processing duplicates in Excel tables. Program key functions: a search across rows or columns; search across an entire table or a specified range of cells; an opportunity to compare by values or formulas.Similar Data Finder for Excel
This add-on helps you to find cells with similar values in Excel worksheets. The program enables you to quickly find mistakes made while entering cell values; easily correct the mistakes; find and mark cells which seem to be incorrect.Tables Transformer for Excel
This add-in for Excel 2000-2013 will allow you to fast and easy transform current tables to construct pivot ones, to divide one table into several ones or to unite two tables in oneCompare Spreadsheets for Excel
A powerful add-on for comparison of Microsoft Excel files. Program features: work with files, tables or the selected range of cells; work with files without opening them in Microsoft Excel.Fix Broken Links for Excel
Microsoft Excel 2000-2013 add-on helps you to find and fix broken links in Excel linked files. Program key functions: search for documents with the broken links, fixing broken links, work with files stored on web-sites and SharePoint servers.
item has less then 1 vote
|OS Support||Windows Install and Uninstall|
|File Size||3.53 MB ( 3,614 KB )|
|Published||Feb 27, 2007 (10 years ago)|
|Updated||Apr 29, 2014 (2 years ago)|
Print Microsoft VBA source code in color of your applications across the entire Microsoft...
What's in SEO PowerSuite? The SEO toolset contains 4 leading-edge apps for all-round...
My Checkbook makes managing your personal finances a snap. With simple daily entry...