Looping page fields in pivot table

I have a pivot table with five page field filters. I'm trying to find
some code that will automatically cycle through all of the filtering
permutations, copy a chunk of cells that are fed by the pivot table
results with each change, and pass it to another worksheet (--pasting
each new data run below the previous one).

BUT, only ~200 of the total number of permutations have underlying data
to be used. So, I want to cycle through a specific list of of page
field selection on a separate sheet.

Any thoughts?

Debra Dalgleish has some code for printing stuff based on each of the page
fields. Maybe you can modify her code to do what you want:

http://contextures.com/xlPivot09.html



[email protected] wrote:
>
> I have a pivot table with five page field filters. I'm trying to find
> some code that will automatically cycle through all of the filtering
> permutations, copy a chunk of cells that are fed by the pivot table
> results with each change, and pass it to another worksheet (--pasting
> each new data run below the previous one).
>
> BUT, only ~200 of the total number of permutations have underlying data
> to be used. So, I want to cycle through a specific list of of page
> field selection on a separate sheet.
>
> Any thoughts?

--

Dave Peterson