View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default Extracting from Pivottables

Too trigger happy

http://j-walk.com/ss/excel/usertips/tip068.htm

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Peo Sjoblom" wrote in message
...
Here is one method

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"John James"
wrote in message
...

Is it possible/practical to extract data from pivottables (apart from
pivotcharts) and if so how?

Pivottables are excellent in analysing, summarising and drilling down
on data, but the subsequent presentation and use of that data appears
very restricted and manual based on my current knowledge.

Are there any relevant tricks or tips & if so where?


--
John James
------------------------------------------------------------------------
John James's Profile:
http://www.excelforum.com/member.php...o&userid=32690
View this thread:
http://www.excelforum.com/showthread...hreadid=525113