Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm trying to reference pivot table cells in another worksheet; a direct cell
reference doesn't work because the data is ever-changing. I figured out the formula if I'm in the same tab, but not from a secondary worksheet. The same-tab formula is: =GETPIVOTDATA("Budget",$A$4,"Office","ATL") How do I re-write that to work from another worksheet? I have many others to do, but I need the basic structure to follow. Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Getpivotdata Question | Excel Discussion (Misc queries) | |||
GetPivotData Question | Excel Worksheet Functions | |||
getpivotdata | Excel Worksheet Functions | |||
GETPIVOTDATA help | Excel Discussion (Misc queries) | |||
GETPIVOTDATA question regarding adding "rows" | Excel Worksheet Functions |