Multisheet Templates

Revision as of 18:05, 4 March 2024 by Colin (talk | contribs)

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

File:Sample Template.xlsx