Thread: How do I link a cell outside a pivot table to one inside the table
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default How do I link a cell outside a pivot table to one inside thetable
You can use the GetPivotData function to extract data from a pivot
table. There are instructions in Excel's Help, and he

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

GPGTDRVR wrote:
I have a pivot table that users enter data outside the table that is
associated to data inside the table i.e. due dates are entered by users for
part numbers inside the table. The table needs to auto re-fresh and needs to
be sortable by data inside the table so when this is done I lose the
association to the data outside the table.


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

Reply With QuoteReply With Quote