How can we setup excel sheet sequence as we like in workflow.

[Gauravbansal]

Hi All,

Would appreciate if someone can help and guide, How can we setup sheet sequence as we like in workflow.

In the attached workflow i have 3 inputs and I want an output with three sheets but i would like to arrange them in an order below

Current sheet arrangement	Required sheet arrangement
AMME	data 1234
1234 Data	1234 Data
data 1234	AMME

Regards, Gaurav B

[alexnajm]

I would make sure the order of the sheet reflects on the Block Until Done tools - i.e. "data 1234" should be out of #1, "1234 Data" out of #2, and so on

[binuacs · Accepted solution]

@Gauravbansal One way of doing this with the help of a batch macro, you need to specify the order of the sheet in a text input tool and then pass it to the batch macro