Input / Dynamic Input Tool with Sheets

[calvincarr29]

I have three branches to my workflow that I later combine, but they each deal with the same excel file but three separate sheets. 

How do I make it so each branch deals with the appropriate sheet?

[binuacs]

@calvincarr29 Sample attached

[OTrieger]

@calvincarr29 
You have here several choices, bellow you have 2.
1. connect each branch to a File Browse tool and then the user will select for each one the respective sheet
2. Use Batch Macro that will take the file and then open each of the sheets, you can use filter tool to create 3 different Marco Output and each connect to a branch.

I'm sure that there are other way, however these should do the job.

[calvincarr29]

@binuacs Is there a way to incorporate the dynamic input tool? Also I'm using the Input Data not the text Input. I cant use the Select tool with the Input Data tool to separate the sheets that I need.

[binuacs]

@calvincarr29 the above workflow is a sample one, dynamic input tool is to read the input files, my understanding is that you have 3 flows and you need to write the 3 flows into separate tabs of the same excel file. if that is the case you can just add a formula tool and update the path and sheet name as mentioned in the given example, then connected to the output file , 

[calvincarr29]

@binuacs Sorry that is not the case. I have a template with at least 20 tabs. I only need three of the tabs. Each tab has it's own branch to format the data / run formulas so I can combine them and produce a single output file. 

I want to prevent using 3 data input tools that specify different sheets. 

I want use one data input tool and have the workflow dynamically pick the 3 appropriate sheets. That way I only have to upload the template once. Can the dynamic Input tool accomplish this?

[apathetichell]

use a batch macro. don't use dynamic input.. filter for your 3 sheet names - feed them into a batch macro. there are numerous entries and workflows on this forum which illustrate how to do this.

[binuacs · Accepted solution]

@calvincarr29 Attaching a sample workflow which filters only the tabs and combine using a batch macro, you can apply formula in each sheet based on the sheet name in the batch macro output