Output to Multiple Excel Files

Question

Hi All,

I have about 150 manager report templates created, and I need to run my data, group by the specific manager and write out the data to the respective reports.  I know how to point the output at the correct report, but i am not sure how to build a flow that groups by manager, writes out the report, then groups by next manager, writes out, etc...  I am new to macros and was trying to do this with an iterative macro, but not sure if i understand well enough to make this work.  I thought i saw a post about doing it with a batch macro, but not sure...?  Any help would be appreciated!

Qiu · Accepted Answer

@RichD 
Use Formula Tool to create the full path.

echuong1 · Accepted Answer

While this is achievable with a batch macro, you don't necessarily need to use one. No need to overcomplicate.

You can use the option to change the output path. I dynamically built the path using a Formula tool.