I have 30 tabs of the same sourced pivot table, but have 10 different project managers. I have project manager as a field name, but was wondering if there was a way to insert some type of filter at the beginning of my file where a project manager could select their name and only their tabs would show up. Currently, each project manager has to manually scroll through and find their project. Hope that makes sense.
thanks
Bookmarks