I have a report that pulls in data from various sites. The data is categorized and I have all categories in a named range "codes". There are over 120 categories that get pulled in but only about half are relevant for this report. I have a pivot table on the report that filters out the irrelevant categories. I have individual tabs for each site (Site1, Site2, etc) that list out all of the categories. Is there a way to automatically hide to rows based on what category is filtered out on the pivot table?