Thread: How to get information from a Pivot TAble without retyping?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote