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?

--
Thx,

JWest