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?
Solved! Go to 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,
Sometimes it is the easiest solution that just goes right over my head. Thanks!!