Multiple Excel Sheets How to Choose specific sheets

[jeh]

I have an excel sheet that has the following sheets:

Sales

Sales (2)

Sales (3)

Receipt 

Receipt (2)

Receipt (3)

How do I get only the sheets that have the word Sales using dynamic input?

[carlosteixeira · Accepted solution]

Hi @jeh 

My be this help you...

Best Regards

[NicholasM · Accepted solution]

Hey @jeh ,

I would recommend using the input tool to pull in a complete list of all sheet names. This can be followed by a filter to only pull in only sales sheets, then a dynamic Input. See photo and Workflow Attached for an example. 

Hope this helps, 

[jeh]

Sometimes it is the easiest solution that just goes right over my head. Thanks!!