Hi All,
I have a workflow which needs to be run on 50 sheets ( placed within the same workbook), is there a smarter way to do that? I am not familiar with Macros, looking for an alternate approach, if any.
@Deepakchandrashekar Refer this:
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-create-a-batch-macro-for-reading-multiple-files-with/td-p/821808
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Batch-Macros-for-Multiple-excel-files-with-different-schemas/td-p/1142685
@Deepakchandrashekar wrote: Hi All,I have a workflow which needs to be run on 50 sheets ( placed within the same workbook), is there a smarter way to do that? I am not familiar with Macros, looking for an alternate approach, if any.
Hello,
An efficient approach for running a workflow across multiple sheets without using Macros is to use Excel formulas combined with VBA. Here's a simple method: mypoints search
Define your workflow in one sheet.
Use Excel formulas like INDIRECT to reference different sheets dynamically.
Automate the process with a small VBA script to iterate through each sheet and apply the workflow.
This method is user-friendly and avoids complex Macro coding.Best Regards,Sonia Lewis
