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. Smarttracker-Enterprise (one site, unlimited users
   Smart Tracker-Enterprise - Software to track issues in your organization
2. Basic Balance Sheet Template
   The basic balance sheet template is an Excel spreadsheet for those who prefer to do their own valuation and/or analysis and would rather not spend the significant time needed to create the financial statements.
3. ABC Amber QuattroPro Converter 1.03
   ABC Amber QuattroPro Converter is an advanced tool to convert your QuattroPro spreadsheets into any format you wish (PDF, DBF, CSV, XML, XLS, CHM, HTML, RTF, HLP, DOC, TXT, etc.) easily and quickly.
4. Number Manager
   The number manager fills in the gaps in Excel when working with numbers. It allows you to add 15 different number formats that are not part of Excel's built in number formats.
5. AnalyzerXL 5.9.5
   Technical Analysis in Microsoft Excel. Free historical and real quotes into speadsheets.
6. Link Finder for Microsoft Excel
   Use the Link Finder to find and remove hidden links from your Microsoft Excel spreadsheets.
7. Categorizing Data for Excel
   If your problem consists in categorizing or stratifying specific data of your Excel spreadsheet information, then Categorizing Data for Excel is the solution.
8. JEM Plus (Excel Add-in)
   Be Smarter & Faster. Over 40 utilities & 207 worksheet functions
9. ExcelSmartTools Auditor
   ExcelSmartTools Auditor, was developed to help Microsoft Excel users audit and check spreadsheets models.
10. Data Cleaner for Microsoft Excel
    The Data Cleaner is a Microsoft Excel add-in that takes the pain out of modifying your data.
11. DELL Latitude C640 series Security Chip w/PRS
    The DELL Latitude C640 series Security Chip w/Password Recovery Service allows for resetting of DELL Latitude C640 series BIOS passwords. The package includes instructions.
12. Startup Faster! 2004 1.65
    Startup Faster! 2004 is a revolutionary tool to make your computer startup much faster than ever while protecting your hard disk from sudden failure.
13. Lookup Assistant for Microsoft Excel
    The Lookup Assistant is designed to find matching data in one list and load in another.
14. In The Raven Shadow
    In the Raven Shadow is in the best sense an old-fashioned adventure game for all sense-seeking people, which can laugh about themselves. And not only the painting in the decayed house does show a twinkle of the eye.
15. 3D Matrix Core
    Stunning Sci-Fi theme of the core matrix of your system.
16. PalmSlay
    Slay for the Palm handheld...
17. Extract Message Action for InboxRULES
    Extract Message action can automatically extract data from a message (sender's and recipient's info, subject, body, delivery time) when it arrives to MS Outlook account or MS Exchange Server mailbox and store them into a file...
18. Amazing Animals Screen Saver
    Protect your monitor with amazing images of Animals from around the world. See Birds, Butterflies, Wolfs, Owl and many more in this screensaver. This screensaver contains a total of 67 beautiful images.
19. Lavavo Audio CD Ripper 2.00
    Lavavo Audio CD Ripper is the most easy-to-use CD ripper you've ever seen, with only 1 step you can extract CD to MP3, WMA, OGG, APE, VQF or WAV directly; Lavavo Audio CD Ripper has a good-looking and straightforward interface...
20. The Cleaner Professional 4.1
    If you surf the Web or send and receive e-mail, you can't afford to be without The Cleaner! The Cleaner protects your system from Trojan Horses -- destructive programs that masquerade as friendly applications. In addition to Happy99.