Multisheet Templates

Revision as of 17:31, 4 March 2024 by Colin (talk | contribs) (Created page with "Multisheet Templates allow you to create workbook with multiple sheets from a single template designed in Excel. You define ranges for the sets of column and row members avail...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Multisheet Templates allow you to create workbook with multiple sheets from a single template designed in Excel. You define ranges for the sets of column and row members available, then define how to combine them for each output sheet.

For example, we can define two sets of columns and two sets of rows, and use this to create four output sheets.

This input

MultisheetTemplate SampleTemplate.PNG

Creates this output

MultisheetTemplate SampleOutput.PNG