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.

POPULAR DOWNLOADS IN THIS SECTION
Chart Tools for Excel
Investment & Business Valuation
DoneEx XCell Compiler
Profit Loss Report Spreadsheet
DIG
Excel Remove (Delete) Text, Spaces & Character
Excel Convert Numbers to Text Software
eTikr - Free Stock Quotes for Excel
Excel List Compare
Useful Excel macro will compare rows in 2 lists of data based on 1 to 3 columns in each list. Creates a new spreadsheet with matched rows from original 2 lists merged together on the same row and unmatched rows highlighted on separate rows. As the 2...
Download Now!
Excel Invoice Template
Excel Invoice Template, a billing software & invoice software based on Excel, provides a Fill In The Blank invoice form and is capable of calculating invoices. The invoice template provides an intuitionist interface for creating invoices.
Download Now!
Excel Significant Digits (Figures) Software
Quickly format cell numbers as sig. digits in Microsoft Excel. Select a block of cells to change and specify how many digits to round to.
Download Now!
ABC Amber Word2Excel Converter
ABC Amber Word2Excel Converter is an advanced utility which helps you convert tables from DOC (MS Word) files to XLS (MS Excel) easily and quickly. The software supports a batch conversion, a run from command line, more than 50 languages. Batch...
Download Now!
Size: 2.0 MB | License: Shareware | Price: US$16 | Category: Spreadsheets
Monkey Merge Automatically merge multiple Microsoft Word documents (doc files), PDF, RTF and plain text files such as CSV or html files together into one file. Also merge many Excel xls workbooks and worksheets into a single worksheet. Automatically merge multiple Microsoft Word documents (DOC and RTF files) and plain text files such as CSV or HTML files together into one big target file. Also merge many Excel XLS workbooks and worksheets into a single worksheet and combine PDF...

OS: Windows 95, Windows 98, Windows Me, Windows NT, Windows 2000, Windows XP
Software Terms: Doc, Rtf, Xls, Excel, Merge, Word, Pdf, Adobe, Acrobat, Text
Size: 344.0 KB | License: Shareware | Price: US$19.82 | Category: Spreadsheets
Excel Join (Merge, Combine) Multiple Sheets & Combine several Excel files into one sheet or one file. Select many Excel files and this program will take data from all sheets and combine them in Excel.

OS: Windows 95, Windows 98, Windows Me, Windows 2000, Windows XP
Software Terms: Joining, Combining, Merging, One, Two, Three, Four, Five, Six, 1
Size: 994.0 KB | License: Shareware | Price: US$29.95 | Category: Spreadsheets
Advanced Excel Find 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. The Advanced Excel Find is an add-in designed for MS Excel 2000 and MS Excel XP and adds no new workbooks or VBA macros.

OS: Windows 95, Windows 98, Windows Me, Windows NT, Windows 2000, Windows XP
Software Terms: Add-in, Add-ins, Excel, Advanced, Finder, Ms, Microsoft
Size: 394.0 KB | License: Shareware | Price: US$19.82 | Category: Spreadsheets
Excel Sheet Navigation & Management Software Copy, open, move, rename, delete, swap, and switch between worksheets in all open workbooks quickly. This Addin loads into Excel for convenient management of your sheets. Good if you have many worksheets or many workbooks to keep track of.

OS: Windows 98, Windows Me, Windows 2000, Windows XP
Software Terms: Worksheets, Excel Sheet Navigation, Quick Navigate, Open, Move, Rename, Searching, Search, Delete, Copy
Size: 1.8 MB | License: Shareware | Price: US$45 | Category: Spreadsheets
FindReplaceExcel FindReplaceExcel is a find/replace utility to search Excel files for text, values and comments and replace the text inside cells automatically without opening workbooks . The program can search ranges in worksheets. Multiple drives and directories can be searched. Individual worksheets can be searched within workbooks. Cells can be searched for partial text matching and/or case letters. Excel files are backed up before changes are made.

OS: Windows 98, Windows Me, Windows XP
Software Terms: Excel Find, Replace Excel, Batch Excel Replace, Search Excel Workbook, Find Text Excel