That code might cause a problem if the items in the fields are
different. I've uploaded a version that may work better, and could be
used if the field names are different too.
http://www.contextures.com/excelfiles.html
Under PivotTables, look for 'PT0015 - Change Multiple Different Page Fields'
molinaram wrote:
Hi Debra, I saw the sample spreadsheet on your website and was wondering if
the code could be used if the pivot tables are not based on the same data
but have the same page fields. Is this possible?
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html