Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
getpivotdata worksheet
I would like to use the getpivotdata formula in a sheet that does not
contains the pivot Table (the pivot table is on another sheet in the same file), how can I do this?? my sheet name is MARCH =GETPIVOTDATA("Sales",B13,"Month","Apr","Name","Ri chard") |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
getpivotdata worksheet
Change the reference B13 to reference B13 on the sheet with the pivottable:
'Pivot Table sheet'!$B$13 So your formula becomes: =GETPIVOTDATA("Sales",'Pivot Table sheet'!$B$13,"Month","Apr","Name","Richard") HTH, Bernie MS Excel MVP "Brussels1200" wrote in message ... I would like to use the getpivotdata formula in a sheet that does not contains the pivot Table (the pivot table is on another sheet in the same file), how can I do this?? my sheet name is MARCH =GETPIVOTDATA("Sales",B13,"Month","Apr","Name","Ri chard") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
copyright and worksheet protection | Excel Discussion (Misc queries) |