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.
Merge Workbooks 2.0
Merge Workbooks is an Excel macro that will combine several Excel workbooks into one workbook. The user selects the workbooks to merge and the macro copies all the worksheets in those workbooks into a new workbook. The trial version is limited to combining ...
Excel Join (Merge, Match) Two Tables Software 7.0
Combine two MS Excel tables into one based on a common column of data from each table. The two tables can be located in the same Excel file or two different Excel files. Rows from the two unequal tables will line up perfectly without copying and pasting ...
Tables Transformer for Excel 1.1.4
This is a fast and easy way for Microsoft Excel 2000-2007 tables transformation. Tables Transformer for Excel 2000-2007 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 one.
Data transformations for the construction of pivot tables: ...
Excel Import Multiple Excel Files Software 7.0
Import one or many Excel files into a blank MS Excel file. Specify local Excel files and either insert them all into one sheet or individual sheets per file. Excel 2000 or higher required. ...
Worksheet Sort 3.0
Sort worksheets in an Excel workbook A-Z or Z-A. Worksheet Sort will sort the worksheets in an Excel workbook in either ascending (A-Z) or descending (Z-A) order. The trial version is limited to sorting only 10 worksheets in a workbook. ...
Advanced Excel Find 1.4
Is an add-in that makes search through multiple worksheets and workbooks in Excel fast easy and comfortable. It allows you to simultaneously search in values, formulas and comments and more. Once all items are found you can move freely around search results ...
Similar Data Finder for Excel 1.1.4
This add-on helps you to find cells with similar values in Excel worksheets. Similar Data Finder for Excel will help you to find cells with similar values in Microsoft Excel 2000-2007 worksheets. The program enables you to quickly find mistakes made while entering cell values; easily correct the mistakes; find and mark cells which ...
Excel Import Multiple CSV Files Software 7.0
Import many CSV files into one Excel file quickly. Load a list of CSV files into the program and the data will be inserted into a blank workbook. ...
Compare Spreadsheets for Excel 1.1.5
A powerful and convenient add-on for comparison of MS Excel 2000-2007 files. Compare Spreadsheets for Excel is a powerful and convenient tool for comparison of files in Microsoft Excel. How it's work: 1. Start the program (there is even no need to open the tables to be compared). 2. Specify the tables or ranges of cells to be ...
