ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Looping page fields in pivot table (https://www.excelbanter.com/excel-programming/355911-looping-page-fields-pivot-table.html)

[email protected]

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?



All times are GMT +1. The time now is 03:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com