I have created a workflow that I would like to run across multiple sheets with the same schema within my workbook. Note that my workbook contains other sheets that I do NOT want the alertyx workflow to run. Further, the sheets that I will need within the workbook will vary from time to time. Is there a way to create a batch input workflow so that I can select only the sheets that I want from my workbook prior to running?
Hey @mabook617,
I think what you want is an Analytical App like this:
The input tool just gets sheet names then you select which sheets you want. The final macro imports the selected ones (could use a dynamic input there). I have attached both the app and the macro.
Any questions or issues please ask :)
HTH!
Ira