Create a Filter Macro or Split Report Macro

katonyaj

I'm trying to create a filter macro for a report that we use for over 50 locations and over 5k lines that would allow me to filter by entering the name or from a dropdown. Or even if possible, would split the file into separate files based on the filtered name. 

This is as far as I got and now I'm stuck

I have attached a sample report and my attempt at this macro. 

Any advice would be great!

Report.xlsx

Macro.yxmc

jarrod

splitting the file is pretty straight forward:

at the bottom of the config window, there is an option to split the output file from a field.

if you need to filter the macro and run for all locations, i would choose a batch macro to accomplish that task, but you could possibly do it by using groups within the flow itself. From the screenshot below, you look like you want to run single reports, is that correct?