Multiple worksheet order

lillyt2006

I have to create multiple worksheets in a set order in an Excel spreadsheet. My workflow has logic to create about 10 worksheets. Based on the completion of a workflow, the worksheets are being created in that order. (which I do not want) I am also trying to avoid having workflow lines everywhere. Is there a way to have the sheets in a define order?

Workflow

Accepted answers

PanPP

Happy to help. Can you please mark it as a solution so other community members can see.

All comments

PanPP

Hi @lillyt2006

One method you can use to control the sheet order is to use a "Block Until Done" tool. That way, the sheets get added on in the order you want them.

If you have more than three sheets, you can just chain as many "Block Until Done" tools as you need.

Hope this helps, if it does please like this post and if it helps resolve your problem, mark it as a solution. If you have any other questions, please let us know.

Par_O_SE

Using "Block until done" is generally a good practice when writing multiple sheets to the same document as it makes sure that one process is completed prior to initiating the next. Great advice...:)

anandakrishnan

@PanPP Good solutions.

lillyt2006

Thank you for solution.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703