How do I show the report filter items in a range of cells?

J

JWest

Not sure which Discussion Group is appropriate for this question. Please
re-post if necessary.

I want to use the same functionality of the option for a pivot table "Show
Report Filter Pages" to copy those filter values into a range of cells rather
than into a new worksheet tab for each specific item. It is obvious that
Excel is aware of the values of the Multiple Items selected, but I do not
know how to properly extract that data the way this option does to create a
new sheet for each of the selected items within that report filter. Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Slicers and Calculated Items in Pivot Table 2
Pivot table - Filter - no filter by value 0
Word macro that can call cells out of Excel for a find and replace 0
AppleScript - How do I select a text ? 1
Show the item selected from Report Filter in a Pivot Chart 3
filtering dates in a Pivot Table Report Filter 3
Pivot Table Filter Question 0
Storing Multiple Selected Pivot Table Report Filter Values 2

Top