Duplicator
The Duplicator repeats a sheet's formulas and structure across every value in a dimension, such as one tab per department, one section per product, or one layout per time period. It reads the reference cell your NecAccess formulas already use to filter by dimension value and swaps in a different value for each copy.
The sheet must already contain NecAccess formulas before running the Duplicator.
When to duplicate sheets
- Repeat a layout across dimension values such as customers, accounts, or time periods.
- Generate consistent report structures across multiple business units or categories.
- Automate formula replication so filters update correctly for each block instead of relying on manual copy-paste.
- Produce printable reports where each section corresponds to a different dimension value.
Duplicate report content
- In the Add-ins tab, select Duplicator.
- Select the Data Model and Environment.
- Choose the Dimension you want to duplicate across.
- Specify the reference cell that contains the value used by the formulas for duplication.
- Select Ok to generate the duplicated content.
Duplicator settings
| Setting | What it does |
|---|---|
| Data Model | The data model to run the Duplicator against. |
| Environment | The environment to target when more than one is available. |
| Dimension | The dimension to duplicate across. |
| Filter value position for this dimension | The cell where the dimension value is inserted. This cell must be referenced by your existing formulas for the Duplicator to work correctly. |
You have built a financial analysis report using NecAccess formulas filtered by department. Instead of manually copying the layout for each department, the Duplicator generates a separate version for every department in your data model automatically.
- For the Data Model, select GL Transaction Details.
- From the Dimension dropdown, select Analytical Department.
- Set the reference cell where the department value is used to
'Financial Analysis'!$F$7. - Select Ok to generate individual tabs, one per department.
Each tab contains the same report layout, automatically filtered to the corresponding department.
The reference cell must already be used by the NecAccess formulas in your sheet. If it is not, the Duplicator generates the blocks but the filters will not update correctly for each department.