Archive of Mr Excel Message Board
Back to Pivot Tables in Excel archive index
Back to archive home
Getpivotdata
Posted by IML on October 12, 2001 9:02 AM
Let say you have the following formula pointing towards a table named PIVTAB1
=GETPIVOTDATA(PIVTAB1,"1 sum of Fund Value Q4/00")
to retrieve the Fund value of fund 1 for the Q4/00 period.
Is it possible to replace 1 and Q4/00 with cell addresses. If so, what would the format be?
Thanks in advance,
Ian
Re: Getpivotdata
Posted by Barrie Davidson on October 12, 2001 10:11 AM
Hi Ian, would this formula work for you (assumes you have the value 1 in cell A1 and Q4/00 in cell A2)?
=GETPIVOTDATA(PIVTAB1,A1&" sum of Fund Value "&A2)
Regards,
Barrie
Exactly, perfect
Posted by IML on October 12, 2001 10:15 AM
At the same time you were responding I queried www.alltheweb.com in english with "mr excel getpivot data" and got an old mark w post
10078b.htmlstating more or less the same thing. That is one powerful search tool as Aladin and others have suggested.
Thanks again,
Ian
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.