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 a new worksheet for each file;
by creation one common table;
with the performance of calculation: summation, calculation of quantity, calculation of average value, etc.
ExcelPipe Lite (+1 Yr Maintenance) - Automatically Find and Replace across Thousands of Microsoft Excel spreadsheets. Change hyperlinks and UNC paths when servers get renamed; update contact details such as names, addresses and phone numbers; translate... ...