Batch Input Macro on Selected Sheets within Workbook

Question

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?

IraWatt · Answer

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

App Example.yxwz

Example.yxmc