Run the same workflow across multiple worksheets in excel via alteryx

[Deepakchandrashekar]

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. 

[sonia598lewis]

---

@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

1. Define your workflow in one sheet.

2. Use Excel formulas like INDIRECT to reference different sheets dynamically.

3. 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

[nagakavyasri · Accepted solution]

@Deepakchandrashekar Refer this:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-create-a-batch-macro-fo...

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Batch-Macros-for-Multiple-exce...