Re: Pivottable trauma

From: Debra Dalgleish (dsd_at_contexturesXSPAM.com)
Date: 06/18/04


Date: Fri, 18 Jun 2004 19:27:07 -0400

What are you trying extract, why are you using index/match and
getpivotdata, and where are you getting stuck?

didsburyalex < wrote:
> Hi
>
> I'm looking to extract data from a Pivot table to a new spread***, in
> order to not have to type huge numbers of formulae.
>
> i'm using the index formula in combination with hte match formula
> followed by the getpivotdata formuala.
>
> I am now very stuck can anyone help?

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