Re: Pivottable trauma
From: Debra Dalgleish (dsd_at_contexturesXSPAM.com)
Date: 06/18/04
- Next message: Debra Dalgleish: "Re: How to copy formats for a cell?"
- Previous message: RagDyer: "Re: Formulas over multiple worksheets"
- In reply to: didsburyalex: "Pivottable trauma"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: Debra Dalgleish: "Re: How to copy formats for a cell?"
- Previous message: RagDyer: "Re: Formulas over multiple worksheets"
- In reply to: didsburyalex: "Pivottable trauma"
- Messages sorted by: [ date ] [ thread ]