Generating 10 dynamic sheets

[ASHISHKHURANA93]

I have a csv file with following data

Hierarchy	Levels
H1	10
H2	2
H3	3
H4	4
H5	5
H6	6
H7
H8
H9
H10

I want to create sheets only with levels present inside them.

E.g Create 6 sheets in this example named as H1,H2,H3,H4,H5,H6

The template of each sheet will be dynamic.For example the first sheet will have 10 levels.

Alteryx will create H1 sheet with following headers.There will be only 1 row 

T

L1

L2

L3

L4

L5

L6

L7

L8

L9

L10

Alteryx will create H2 sheet with following headers.There will be only 1 row 

T

L1

L2

And so on

[danilang]

Here you go

The attached package contains the workflow that generates the headers and the macro that writes to excel

Once you extract the package to a directory, run the workflow.  The excel file will be created in the  ".\_externals\1" subdirectory

Dan