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 you have the data consolidated into one workbook, you can use the search through features of the Consolidation Assistant to extract ranges from selected worksheets

 Download now     Click to buy from RegNow

User Opinions: 0 votes

Submit your opinions

1. Car Lease Analyzer for Microsoft Excel (Business & Finance > Applications)
2. Analysis Collection for Microsoft Excel (Business & Finance > Spreadsheets)
3. Backup Assistant for Excel (Business & Finance > Spreadsheets)
4. Cell Color Assistant for Microsoft Excel (Business & Finance > Spreadsheets)
5. Chart Assistant for Microsoft Excel (Business & Finance > Spreadsheets)
6. Chart Viewer for Microsoft Excel (Business & Finance > Spreadsheets)
7. Conditional Format Assistant for Microsoft Excel (Business & Finance > Spreadsheets)
8. Consolidation Assistant for Microsoft Excel (Business & Finance > Spreadsheets)
9. CSV File Creator for Microsoft Excel (Business & Finance > Spreadsheets)
10. Data Assistant for Microsoft Excel (Business & Finance > Spreadsheets)
11. Data Cleaner for Microsoft Excel (Business & Finance > Spreadsheets)
12. Data Loader for Microsoft Excel (Business & Finance > Spreadsheets)
13. Directory Lister for Microsoft Excel (Business & Finance > Spreadsheets)
14. Duplicate Finder for Microsoft Excel (Business & Finance > Spreadsheets)
15. Easy Checkbook for Microsoft Excel (Business & Finance > Spreadsheets)
16. Visual Basic Collection for Microsoft Excel (Business & Finance > Spreadsheets)
17. Filter Assistant for Microsoft Excel (Business & Finance > Spreadsheets)
18. Histogram Creator for Microsoft Excel (Business & Finance > Spreadsheets)
19. Link Finder for Microsoft Excel (Business & Finance > Spreadsheets)
20. Loan Assistant for Microsoft Excel (Business & Finance > Spreadsheets)
21. Lookup Assistant for Microsoft Excel (Business & Finance > Spreadsheets)
22. Macro Button Assistant for Microsoft Excel (Business & Finance > Spreadsheets)
23. Macro Remover (Business & Finance > Spreadsheets)
24. Merge Assistant for Microsoft Excel (Business & Finance > Spreadsheets)
25. Microsoft Excel Tool Kit for Microsoft Excel (Business & Finance > Spreadsheets)
26. Money Tracker for Microsoft Excel (Business & Finance > Spreadsheets)
27. Multi-Cell Goal Seeker for Microsoft Excel (Business & Finance > Spreadsheets)
28. Name Splitter for Microsoft Excel (Business & Finance > Spreadsheets)
29. Password Assistant for Excel (Business & Finance > Spreadsheets)
30. Pivot Table Assistant for Microsoft Excel (Business & Finance > Spreadsheets)