|
|||
In this section, you will learn how to work with previously saved consolidation models. |
|||
2. The dialog has two tabs, Edit and Copy. Edit Tab The first dropdown lists the workbooks containing saved consolidation models; as you select one, the second dropdown shows the consolidation models saved in the selected workbook. Information related to the selected model shown in this tab includes consolidation data range, mathematical function used, target range for consolidation results, and the structure of sheets to consolidate. Once you select the model, click on the Consolidate button and the selected model will run quickly. |
|||
Copy Tab This tab is an additional utility for advanced users -the more you master this tool, the more useful it will become. Use this functionality to copy existing models from one workbook to another. This is useful if the target workbook has the same consolidation structure as the source workbook. |
|||