You can use the GetPivotData function to extract data from a pivot
table. Perhaps you could use it to pull data and total the results.

There are instructions and examples in Excel's Help, and he

http://www.contextures.com/xlPivot06.html

EasleyK wrote:
OK, I'm trying to create some type of report card.

Say I have multiple pivot tables, all having the same general Rows or Pages
defined (region, state and individual). However, each of these pivots have
a different set of columns and data.

I'd like to create a master pivot table that will contain all of the data
from the 3 or 4 ther pivot tables. So all measured data will be present at
the Column and Data level for each visible Row.

Any ideas?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html