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.

  1. Click Duplicator in the Add-ins tab.

  2. In our example, we duplicate the Financial Performance dashboard by department. We select the department field to duplicate and select the cell $F$7 that is used as a filter in the formulas for the department .

  3. Click OK. A sheet for each department is automatically created.