HOW TO REPLICATE THE SAME WORKFLOW FOR MULTIPLE SPREADSHEETS?

Question

Hey guys, I have created a workflow that I want to apply to many files on excel.

I tried to use the xlsx wildcard but I want to edit specific ranges of rows. For example I need to select specific range of data ( same on each file) and then process. As wildcard consolidates all data I cannot select the range dynamically. As such I have created a workflow that applies to only one file and need to dynamically replicate that to all the others which are in the same folder.

Any idea anyone?

JosephSerpis · Answer

ok that makes the task easier as you then don't have to dynamically find out the sheet names. The learning resources @BrandonB provided will help to learn batch macros. This community link showcases the solution I believe you need (Batch Macro with file paths).

tolis · Answer

@BrandonB @JosephSerpis  Is there a way to use multi row formula to dynamically select the range of data that I need in order to move on?

tolis · Answer

The sheet names are the same but file names are not