How to get information from a Pivot TAble without retyping?
 

Hi,

Someone has made a Pivot Table with a bunch of figures in a spreadsheet.
I'd like to link to one of the cells in the Pivot Table instead of typing it
up manually.
Is this possible?

Thanks in Advance

Janet

How to get information from a Pivot TAble without retyping?
 

You can use the GetPivotData function to return data from a pivot table.
There's information he

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


Grd wrote:
Hi,

Someone has made a Pivot Table with a bunch of figures in a spreadsheet.
I'd like to link to one of the cells in the Pivot Table instead of typing it
up manually.
Is this possible?

Thanks in Advance

Janet


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

How to get information from a Pivot TAble without retyping?
 

thanks
thats what i needed



"Debra Dalgleish" wrote:

You can use the GetPivotData function to return data from a pivot table.
There's information he

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


Grd wrote:
Hi,

Someone has made a Pivot Table with a bunch of figures in a spreadsheet.
I'd like to link to one of the cells in the Pivot Table instead of typing it
up manually.
Is this possible?

Thanks in Advance

Janet


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