software

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 amp; if so where?--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=525113Here is one method

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;John Jamesquot; gt; wrote
in message ...
gt;
gt; Is it possible/practical to extract data from pivottables (apart from
gt; pivotcharts) and if so how?
gt;
gt; Pivottables are excellent in analysing, summarising and drilling down
gt; on data, but the subsequent presentation and use of that data appears
gt; very restricted and manual based on my current knowledge.
gt;
gt; Are there any relevant tricks or tips amp; if so where?
gt;
gt;
gt; --
gt; John James
gt; ------------------------------------------------------------------------
gt; John James's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32690
gt; View this thread: www.excelforum.com/showthread...hreadid=525113
gt;Too trigger happy

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

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;Peo Sjoblomquot; gt; wrote in message
...
gt; Here is one method
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Northwest Excel Solutions
gt;
gt; www.nwexcelsolutions.com
gt;
gt; (remove ^^ from email address)
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;John Jamesquot; gt;
gt; wrote in message
gt; ...
gt;gt;
gt;gt; Is it possible/practical to extract data from pivottables (apart from
gt;gt; pivotcharts) and if so how?
gt;gt;
gt;gt; Pivottables are excellent in analysing, summarising and drilling down
gt;gt; on data, but the subsequent presentation and use of that data appears
gt;gt; very restricted and manual based on my current knowledge.
gt;gt;
gt;gt; Are there any relevant tricks or tips amp; if so where?
gt;gt;
gt;gt;
gt;gt; --
gt;gt; John James
gt;gt; ------------------------------------------------------------------------
gt;gt; John James's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=32690
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=525113
gt;gt;
gt;
Thanks, Peo.

I hadn't considered using the drill-down facility for this type of
purpose. If the drill-down is more summarised than the original data
upon which the Pivottable was based, then this has interesting
potential for summarising data through a quick, simple, low-error
process.

Do you know whether the table produced is a summarised version of the
original data or if it retains all of the original detail? I'm hoping
it is summarised.

In any case, I suspect there might be some potential here because my
recollection is that the drill-down works on any figure in any
pivottable.

Cheers,--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=525113You can use the GetPivotData function to extract data from a pivot
table. There's information in Excel's Help, and he

www.contextures.com/xlPivot06.html

John James wrote:
gt; Is it possible/practical to extract data from pivottables (apart from
gt; pivotcharts) and if so how?
gt;
gt; Pivottables are excellent in analysing, summarising and drilling down
gt; on data, but the subsequent presentation and use of that data appears
gt; very restricted and manual based on my current knowledge.
gt;
gt; Are there any relevant tricks or tips amp; if so where?
gt;
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html