I know how to write output to different sheets in excel, but how do I re-order the sheets. ie I want specific sheets to be first/ second etc in the oupt workbook.
I tried Block until done, but unable to change the order of the output sheets
Block until done should do the trick.
Or you can try in output options sheet or range.
where are you getting stuck can you share the workflow?
@Nicole_Marx One way of doing this with the batch macro