how do i link to a pivot table to get data dynamically
 

I need to link a sheet to a pivot table in the same workbook to get the data
value from the pivot table. This also has to be updated dynamically as the
pivot table changes. Can this be done and how.

how do i link to a pivot table to get data dynamically
 

You can use the GETPIVOTDATA function to extract data from the pivot
table. There's information in Excel's Help, and he

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

Michael001 wrote:
I need to link a sheet to a pivot table in the same workbook to get the data
value from the pivot table. This also has to be updated dynamically as the
pivot table changes. Can this be done and how.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

how do i link to a pivot table to get data dynamically
 

Hi Debra
Thank you very much for your response, I will give this a go and hopefully
resolve my problem.
Regards
Michael
"Debra Dalgleish" wrote:

You can use the GETPIVOTDATA function to extract data from the pivot
table. There's information in Excel's Help, and he

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

Michael001 wrote:
I need to link a sheet to a pivot table in the same workbook to get the data
value from the pivot table. This also has to be updated dynamically as the
pivot table changes. Can this be done and how.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html