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

Dynamo Nath

Board Regular
Joined
Aug 5, 2009
Messages
142
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?
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Dynamo Nath

Board Regular
Joined
Aug 5, 2009
Messages
142
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:

Code:
Dim centre As PivotItem

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

Dynamo Nath

Board Regular
Joined
Aug 5, 2009
Messages
142
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 :)
 

Watch MrExcel Video

Forum statistics

Threads
1,127,204
Messages
5,623,357
Members
415,969
Latest member
Rey99

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top