Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping page fields in pivot table
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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use multiple page fields in pivot table | Excel Worksheet Functions | |||
Pivot Table Page fields | Excel Discussion (Misc queries) | |||
Pivot Table page fields | Excel Discussion (Misc queries) | |||
How do I set up filter for page fields in pivot table? | Excel Discussion (Misc queries) | |||
Pivot Table Page Fields | Excel Discussion (Misc queries) |