Advanced Consolidation Manager is an MS Excel add-on that merges and consolidates data from multiple files in just one program run. With this tool, users can process any number of files and combine data from different sources into a single document, streamlining the data consolidation process.

One of the key advantages of Advanced Consolidation Manager is its ability to process any number of files per one program run, making it ideal for situations when you need to combine data from multiple Excel files. It offers several grouping options, such as creating a new worksheet for each file or combining data into a single common table.
The software also allows for various calculations to be performed, including summation, calculation of quantity, and average value. This allows users to easily consolidate and analyze data from different sources.
If you frequently need to consolidate data in similar files or receive regular reports in Excel format, Advanced Consolidation Manager offers a straightforward solution. Simply specify which files and worksheets to combine, and the software takes care of the rest, storing the results in a common worksheet or split across several ones.
With its extensive customization options, Advanced Consolidation Manager makes it easy to group worksheets in different Microsoft Excel files, making it simple to work with complex data sets. The ability to specify a common range for consolidation across all selected worksheets further streamlines the process.
Overall, Advanced Consolidation Manager is a must-have tool for anyone looking to simplify and expedite the process of consolidating and analyzing data in Microsoft Excel. Its advanced features and ease-of-use make it the perfect solution for both occasional users and power users alike.
Version 1.1.1: Support for Microsoft Excel 2010 Beta has been added.