@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
