Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
getpivotdata in excel 2007
=+GETPIVOTDATA(pivot1,$A$3 & " " &B$2 & " " &A5)
I'm trying to return pivot table data to another sheet. The range of the pivot table is called "pivot1" and the reference cells represent (name of doc), (date), (procedure type). I get a REF# I have spent hours already and need a solution fast. Please |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
getpivotdata in excel 2007
What formula do you get if you type an equal sign, then click on a data
cell in the pivot table? Adapt that by replacing the item names with cell references. For example: =GETPIVOTDATA("Qty",pivot1,"Doc",$A$3,"Date",$B$2, "ProcedureType",$A5) Fern wrote: =+GETPIVOTDATA(pivot1,$A$3 & " " &B$2 & " " &A5) I'm trying to return pivot table data to another sheet. The range of the pivot table is called "pivot1" and the reference cells represent (name of doc), (date), (procedure type). I get a REF# I have spent hours already and need a solution fast. Please -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 GetPivotData Function | Excel Discussion (Misc queries) | |||
GETPIVOTDATA in Excel 2007 | Excel Discussion (Misc queries) | |||
GETPIVOTDATA in Excel 2007 | Excel Worksheet Functions | |||
GETPIVOTDATA in Excel 2007 | Excel Worksheet Functions | |||
Dynamic Getpivotdata in Excel XP | Excel Worksheet Functions |