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.
item has less then 1 vote
|OS Support||Windows Install and Uninstall|
|File Size||3.53 MB ( 3,614 KB )|
|Published||Feb 27, 2007 (13 years ago)|
|Updated||Apr 29, 2014 (6 years ago)|
Export EML File to Outlook PST 1 hour ago
softaken 2 hours ago
Put Bates Numbers in PDF 2 hours ago
Set Bates Number to PDF 2 hours ago
Outlook MSG Print to Adobe PDF 2 hours ago
MSG File Export to PDF Format 2 hours ago
Open MSG to PDF 2 hours ago
SysInfoTools VBA Password Recovery 2 hours ago
Outlook Save Message File 3 hours ago
Antamedia HotSpot Software 128 times
Advanced ETL Processor 122 times
Dwyco VideoChat Community 120 times
Power Spy 119 times
VyprVPN for Mac 115 times
System Mechanic Free 110 times
ACDSee 105 times
nanoCAD Plus 103 times
Database Workbench Pro 101 times
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|
Reviews of Advanced Consolidation Manager 1.1.1You can be the first to write a review of Advanced Consolidation Manager!
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.MAPILab Find and Replace
MAPILab Find and Replace for Excel is an advanced version of the "Find and Replace" function. The add-on has a number of benefits: simultaneous work with several files; saving and downloading retrieval requests as templates for reuse and other.