| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing data in pivot tables
Hi, I'm trying to access data sitting inside a pivot table. When I
record a macro, it uses the GETPIVOTDATA function. ActiveCell.FormulaR1C1 = _ "=GETPIVOTDATA(""MR#"",R10C2,""Biopsy Year"",1993,""family hx2"",""U"")/GETPIVOTDATA(""MR#"",R10C2,""Biopsy Year"",1993)" Is there a more direct way to access the data without having to set the value within another cell? David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot tables - Editing the data source shared by multiple pivot ta | Excel Discussion (Misc queries) | |||
| Pivot Table accessing data from OLAP cube | Excel Worksheet Functions | |||
| Pivot table accessing external data | Excel Discussion (Misc queries) | |||
| Accessing Pivot Table's Data in VBA | Excel Programming | |||
| Accessing Pivot Table's Data | Excel Programming | |||
Threaded Mode
