Consolidation Assistant for Microsoft Excel

The Consolidation Assistant is designed to help you consolidate data from multiple workbooks or from multiple worksheets.

Description of Consolidation Assistant for Microsoft Excel:

Combining worksheets from a list of workbooks

Selecting a set of workbooks and specifying a range name that identifies the data range to be extracted.

The first approach, combining worksheets from a list of workbooks, is a two step operation. First you would run the first option on the above menu and select the files containing the worksheets to be consolidated. This creates a list of workbooks and worksheets. For those sheets you wish to consolidate, type the name to use in the consolidated file to the right of the existing name. The set of names you specify must each be unique. Once you have done this, select the range containing the new sheet names and run option two on the above menu. Blank cells in the selection will be ignored. When the consolidation is finished, you will end up with a workbook containing each of the sheets that you specified.

When consolidating workbooks, you have two choices: converting the sheets to values or copying the entire sheet. The first approach is the one to use if you have range names used in the formulas, and these range names can have different values. Excel by design will use the first range name that is copied into the consolidation workbook. This rang name may not be what you want used for every sheet. And, sometimes it creates local names, so that you end up with the global name used by some sheets, and the local names on other sheets. If you do not use range names in the formulas, then copying the entire sheet allows you to retain formulas that may be of use to you.

The Consolidation Assistant has several features that allow you to better view your data. One freeze panes on all selected sheets. Another sets the same cell on all selected sheets to the upper left corner. And at the same time sets the zoom to the same setting..

Once 29.95

See Also: All products from Macro Systems

1. Bogemic Docs
   Bogemic Docs is a useful tool that accelerates and simplifies the documentation process in a small business office with a minimal investment.
2. Real Option Valuation 1.0
   The Real Option Valuation model by Excel Business Tools
3. Configuration Management Spreadsheet
   This impact zone includes all the controls required for hardware and software configuration. The price includes a subscription to a full year of updates.
4. Time Sheet
   This extremely easy and simple to use Excel Time Sheet will keep track of your employees hours. It allows you to specify and set unpaid breaks in 5 minute intervals on a daily basis.
5. ABC Amber HTML2Excel Converter
   ABC Amber HTML2Excel Converter is an advanced utility which helps you convert tables from HTM files to XLS (MS Excel) easily and quickly. The software supports a batch conversion, a run from command line, more than 50 languages.
6. Excel Levels 1 and 2 Training
   Excel Levels 1 and 2 Courses
7. ASAP Euro Converter
   The ASAP Euro Converter is an easy to use, professional Euro conversion program, which automates the process of converting your financial data to Euro and vice versa.
8. PerlXL Add-In Builder
   The PerlXL Add-In Builder lets you build custom, compiled XLL Excel Add-In files using nothing but Perl and the Add-In Builder. Generated XLL files can be redistributed and installed on machines that don't even have perl installed.
9. Formula Ref Changer and Sheet Index Creator
   Change formulae references in a flash. Create a index sheet with links.
10. DB for Outlook 2002
    DB for Outlook provides Microsoft. Excel and Outlook users to develop a database from select e-mails.
11. Marbles2
    Marbles 2: Puzzle game sequel from DynoTech Software. - Stack colored marbles in matching cups. Enjoy some of your favorite classical background music.
12. My Daily Friend - Professional
    My Daily Friend is probably the most powerful journal keeping utility on the market. It provides a unique approach to journal writing. Unlike other journal writing software products, My Daily Friend can ask you questions, much as a friend would do.
13. xGomoku for Palm
    Gomoku is played between two opponents on a board by making moves with black and white men called stones. One of the players has at his disposal the black stones and the other player has white stones.
14. My Stuff Deluxe Inventory
    My Stuff Deluxe - Similar to My Stuff except that this package enables unlimited number of pictures, repairs, maintenance, receipt catalogs. Much more extensive reporting abilities.
15. Planetary Defense
    Planetary Defense is a space strategy game where you take charge of a planets defenses against waves of attacking aliens. Defend against missiles, multiple warhead rockets, cloaked starships, meteors, homing missiles and laser-armed satellites.
16. X-Cipher for Windows
    X-Cipher - Secure Encrypted Communications The Internet is a wonderful shared transmission technology, allowing any one part of the Internet to communicate to any other part of the Internet.
17. Pocket Email Checker
    Pocket Email Checker gives you full control over POP3 accounts when you are on the move, away from desktop PC's arsenal. It is easy to check accounts, preview messages and delete unwanted ones directly on a server before download.
18. The Shakespeare Collection 1.0
    A classic collection of inspiring and beautiful notecards that are formatted and ready to print as needed. These cards can be used for all occasions and all types of personal communication.
19. VectorEngineer LT
    VectorEngineer Pro-Tools is a complete technical drawing and multi-purpose cad system that offers all the features required to create accurate professional drawings, working drawings, designs, plans...
20. AuldLangSyne Screen Saver
    Hey! It's a New Years Eve party of the desktop of your PC. Why not have New Years all year round? This is a sprite based screensave using animated gif images.