I am new with Excel VBA so please bear with me.

I have a sales report that has autofilter turned on. I have two filters - one for sales department and one for sales associate. Currently, I am filtering data for each sales department then sending a report to each department's sales manager. Then I am running the second filter with sales associates so I can print each individual their own report.

Right now, I am doing this manually and by macro. The trouble with the macro is that there is high turnover and I have to keeping names. Is there a way to automate this process with VBA?

Thank you.