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.
Download
3.53 MB
929downloads
0this week
$39Shareware
0reviews
Screenshots
About Advanced Consolidation Manager
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.
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.
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
No reviews yet. Be the first to review Advanced Consolidation Manager.
Used Advanced Consolidation Manager? Tell other visitors what you thought.
Log in to write a reviewOther products by this publisher
-
Compare Spreadsheets for Excel 1.1.9
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 1.1.5
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 1.2.3
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.
Most viewed Windows Spreadsheets
-
1
LAselect 2.0
Unclutter Your Spreadsheets But Keep On Sorting! Excel's sorter is too limited for the things people use spreadsheets for. Forcing them to clutter the sheet. LAselect moves the sorting process completely away from sheet to VBA.
- 2 Excel Join Multiple Cells Into One Software 7.0 Merge data that spans over multiple rows into one row or multiple columns into one column in MS Excel. Separating character(s), such as comma, space or comma-space, can be added. Excel 2000 or higher required.
-
3
MITCalc 1.73
MITCalc is a multi-language calculation package includes solutions for gearing, belt, springs, beam, shaft, tolerances and many others. MITCalc support 2D and 3D CAD systems, Imperial and Metric units and many international standards ANSI, ISO, EN...
- 4 DoneEx XCell Compiler 2.6 Excel workbook copy protection tool, compiles XLS to EXE application (which requires MS Excel to run) with securely hidden formulas and VBA code. Main features:copy protection with regkey; create trial/demo of workbook; https://DoneEx.com
-
5
CDBF - DBF Viewer and Editor 2.45
A powerful database viewer and editor that allows home and business users to access
databases directly using the familiar Windows interface. No programming skills needed!
CDBF offers everything you need for working with databases.
-
6
ABA Spreadsheet Convert 2.63
ABA Spreadsheet Convert allow to save the workbooks from directory into another formats.
Supported the most popular workbook formats including MS Excel, Lotus 1-2-3, Quattro Pro, Open Office.
-
7
Pop-up Excel Calendar 1.77
Pop-up Excel Calendar shows you a date picker when you activate a date cell in Excel, so that you can pick or select date value from the calendar by clicking mouse, instead of typing in manually, thus saving time and avoiding format mistakes.
- 8 ExcelPipe Find and Replace for Excel 7.6 Batch Search and Replace multiple Excel spreadsheets. Change hyperlinks and UNC paths when servers get renamed, update names, addresses and phone numbers, translate with find/replace lists. Automatically handles passwords. Unicode compliant
-
9
Excel Compare 3.0
Track differences and compare Microsoft Excel files and spreadsheets with Excel Compare. Excel Compare saves time by eliminating the file comparison routine, and improves comparison precision by telling you exactly what and where has been changed.
- 10 AnalyzerXL Package 6.1.39 Trading and stock quotes downloading software for Microsoft Excel. Library of 165 technical analysis functions, historical and real time quotes downloaders, portfolio tracker.
Most downloaded Windows Spreadsheets
-
1
MITCalc 1.73
MITCalc is a multi-language calculation package includes solutions for gearing, belt, springs, beam, shaft, tolerances and many others. MITCalc support 2D and 3D CAD systems, Imperial and Metric units and many international standards ANSI, ISO, EN...
-
2
CDBF - DBF Viewer and Editor 2.45
A powerful database viewer and editor that allows home and business users to access
databases directly using the familiar Windows interface. No programming skills needed!
CDBF offers everything you need for working with databases.
-
3
ABA Spreadsheet Convert 2.63
ABA Spreadsheet Convert allow to save the workbooks from directory into another formats.
Supported the most popular workbook formats including MS Excel, Lotus 1-2-3, Quattro Pro, Open Office.
- 4 DoneEx XCell Compiler 2.6 Excel workbook copy protection tool, compiles XLS to EXE application (which requires MS Excel to run) with securely hidden formulas and VBA code. Main features:copy protection with regkey; create trial/demo of workbook; https://DoneEx.com
-
5
CDBF for DOS 2.99
CDBF for DOS is a powerful database viewer and editor that lets individuals and business users access databases directly without programming via the text interface. The program can repair corrupt database file headers.
-
6
Pop-up Excel Calendar 1.77
Pop-up Excel Calendar shows you a date picker when you activate a date cell in Excel, so that you can pick or select date value from the calendar by clicking mouse, instead of typing in manually, thus saving time and avoiding format mistakes.
-
7
Advanced Find & Replace for Excel 4.5.4
The Ablebits.com Advanced Find & Replace enhances Excel's built-in Find with simultaneous search in values, formulas and comments in all opened or selected worksheets and workbooks. The add-in works in Excel 2003 - 2010.
-
8
Excel Compare 3.0
Track differences and compare Microsoft Excel files and spreadsheets with Excel Compare. Excel Compare saves time by eliminating the file comparison routine, and improves comparison precision by telling you exactly what and where has been changed.
- 9 AnalyzerXL Package 6.1.39 Trading and stock quotes downloading software for Microsoft Excel. Library of 165 technical analysis functions, historical and real time quotes downloaders, portfolio tracker.
-
10
Canadian Postal Codes 1.0
Download the Canadian Postal Codes database. 765 344 precise (6 characters format) records are in the Canadian Postal Codes package. The package includes: Postal code, Latitude, Longitude. Latitudes and longitudes are to within 15 digits after comma