Hello!
I'm trying to create pivot tables with a filter for one variable, but each filter selection needs to be on a different worksheet. In the example file, I have cases for agents A, B, and C. I need to create a worksheet for each agent like the tabs in the example. Since I have 50+ agents that can change every month, how can I get the filter to change for each one?
Thanks!
Bookmarks