hiding rows based ona filtered pivot table

[rinxman]

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?

 

[Fazza]

Hi.

I don't understand the setup. It sounds like it might be easier with query tables or similar alternative (such as ADO recordsets) and having the filtering done using SQL (in the query tables or alternative). These allow working with data in Excel in similar ways to databases.

HTH, Fazza

 

[rinxman]

Thanks, Fazza. I know it's a bit confusing. The data comes out of scheduling software. The way it has to be pulled is by site. Also, all categories of schedules get pulled (breaks, vacation, lunch, meetings, etc). For the report that this data feeds, not all categories are needed all of the time, so I was wanting to hide the rows for the data that is unselected. I have a macro that takes the data from the report and puts it on the individual site tabs (each site has it's own report so this has to be done run for each report). That data rolls up into an all-inclusive view, but the individual site data is needed too in case there are any large variances. Since only about half of the categories are looked at I was wanting to hide them on the individual site tabs to make the report easier to look at, so we're not looking at a report that is half zeroes or irrelevant data.