|
This useful tool makes easy the process of to consolidate information proceeding from different workbook. but from the same range. |
This utility is contained within of Consolidator tool. It is useful when you often create and execute the same model; in other words, the same model with the same data. |
|
After you have saved a model, you can execute it.
When you select the model that you want to execute...... |
It enables to copy consolidation models from a workbook to another. For this objective, the workbooks containing the consolidation models must be open. |
|
Do you only wish to export any sheets of your workbook? Use the "Export sheets as..." tool, and simplify this task. |
We often lose valuable time doing repetitive tasks, e.g. we want to hide the headings in several sheets of the workbook, we will have to do it one at once. |