Hello All,

Not sure if this is possible but hopefully one of you geniuses can figure this out...

EN BG Report (Working Draft).xlsx

I would like a macro that will Save as PDF and then readjust filters and save again and again and again..

The current filter is "-" and "Anastos". I would like the file to save as Anastos.pdf
The next file the filter would need to adjust to "-" and "Anderson" (The next name on the filter) and save as Anderson.pdf

I would like to print off all names as PDFs in my filter while keeping the "-" as it represents the headers and spacing.

I much appreciate everything you guys do here!!!

Thanks!

Jason