Indirect eq'n to link info from vba-generated worksheet to summary
 

Hi,

I've used vba to create new worksheets. On these worksheets, pivot tables
are automatically generated which get their page filters from Column C on my
Summary Sheet. So far so good!

My problem is using the Indirect function to link pivot table fields back to
my summary sheet. Since I don't know the name of sheet (which are equal to
the values entered in Column C on my Summary sheet) or the position of the
pivot table totals in advance, I need an "Indirect" equation to locate pivot
table totals and to insert them into adjacent totalling fields to the right
of the my user-entered page filters.

Here is my indirect equation so far:

=INDIRECT("'"&C14&GETPIVOTDATA("ACTUALS",ITB202123 P!$D$11,"ActivityII","$"))

Does anyone have any insights using Pivot table references in conjunction
with Indirect functions?

Thanks in advance!

--
Kent Lysell
Financial Consultant
Ottawa, Ontario
W: 613.948-9557