hiding rows based ona filtered pivot table

rinxman

Board Regular
Joined
Mar 20, 2009
Messages
60
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?
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,368
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

Board Regular
Joined
Mar 20, 2009
Messages
60
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,514
Messages
5,596,612
Members
414,080
Latest member
penguin23

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top