Duplicator

The Duplicator is used to create multiple copies of an existing sheet based on a Dimension. A generic trial balance can be copied for each department.

Note

A sheet created with Excel Add-in Formulas is necessary before attempting to duplicate the sheet.

  • Click on Duplicator in the Excel Add-in tab.
    Example

    Duplicate the Financial Performance Dashboard by department:

    1. Click on Duplicator to choose the department field to duplicate and select the cell $F$7 that is used as a filter in the formulas for the department.
    2. Click on OK.
    3. A sheet for each department will automatically be created.