There are a few sample files here that you could adapt to your worksheet:
http://www.contextures.com/excelfiles.html
Under PivotTables, look for
PT0016 - Change Page Fields With Cell Dropdown
PT0015 - Change Multiple Different Page Fields
PT0008 - Change Multiple Page Fields
johnb wrote:
I need to view data, eg, gender, age, ethnicity and several views on one
worksheet. Can all these views(seperate pivottables) have a common
xlPageField?
Each PT is grouped on Months on a Row and gender, age, ethnicity etc on
lefthand column.
Its bit like having a dropdown combo box who selection act as a filter for
many pivottables. Any suggestion as to how I crack this one??
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html