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

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

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,567
Messages
5,625,547
Members
416,116
Latest member
Joemamasuka

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