Can I index through a Pivot Table page field list? [Excel 2003]

[Dynamo Nath]

I've created a pivot table and I'd like to index through each "value" in the page field and then copy the results to another sheet, one sheet per field returned.

I can't figure out if it's possible to index through the list though. Is it possible?

 

[Derek Brown]

I don't understand what you mean by "index through".
Do you mean the 'Show Pages' feature of a pivot table?
If so, here is an Excel 2007 example but it can also be done in Excel 2003:
http://www.youtube.com/watch?v=n5cC1n0_t2U&feature=results_video&playnext=1&list=PLA94258EAD6500203

 

[Dynamo Nath]

Hi Derek,

I wanted to create a pivot table that had items a, b & c as page fields. Then I wanted to select a, copy the data to a new, then repeat for b & c or however many page items there were. This is what I did in the end:

Dim centre As PivotItem

For Each centre In Worksheets("Pivot_Table").PivotTables("utilisation").PivotFields("Centre").PivotItems
.
.
.
Next centre

 

[Derek Brown]

As you are not wanting to create a pivot table, for each page field, as a pivot table on separate worksheets, perhaps it would be better to split the data across worksheets using the advanced filter?
http://ddalgleish.hubpages.com/hub/Filter-Excel-Data-to-a-Different-Sheet

 

[Dynamo Nath]

I'm not sure that using advanced filter would have done what I needed because of how I needed to summarise it. I needed to filter by one category and then sum another one.

All works now though