| 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 |
| 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 | |||
Threaded Mode
