Repeat workflow for multiple sheets from a file

I have a file with Corporate, Finance, Tax, and Other sheets. I want to run each through the same workflow and output each to its own sheet in the new output file.. ChatGPT says I should create a batch macro and use a Control Parameter to send each sheet name through, but I don't understand how to connect the input file to the control parameter and then connect that to the batch macro. Help!

Workflow

Accepted answers

binu_acs

@ppatane I updated the workflow to create a new file and save the Excel sheets as it is

Create_File_.yxzp

All comments

aatalai

If you have the same schema, you can use the dynamic input tool

alexnajm

You can read a list of sheet names in a workflow, then pass that list of sheet names into the control parameter part of your batch macro.

The batch macro will be the workflow you mentioned, with the Control Parameter connected to your Input Data to update the sheet

Screenshot 2025-10-21 072735.png

binu_acs

@ppatane Sample workflow attached

Create_File_.yxzp

ppatane

Hi @binu_acs ,
A couple of things - I see when you ran it, you got three different files, I go 3 of the same. But I am trying to get all the sheets to export to the same file. Would I need to get a Block Until Done in there somewhere? I am on point with both you and @aatalai , I just don't know how to open the appropriate sheets from the input file, work on it and then save each sheet to the same output file. This is what I'm getting using the Dynamic Input Tool

binu_acs

@ppatane , you want the output in a different file with the same sheets with data? is it like creating a new copy of the same file?

binu_acs

@ppatane I updated the workflow to create a new file and save the Excel sheets as it is

Create_File_.yxzp

ppatane

@binu_acs There will be intermediate steps from input to output

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703