| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Data field
I have an exsisting pivot table that i would like to be able to pull
data from a certain intersection point. I.e pivot table Accrual Paid Month Jan 10000 500 Feb 0 200 Mar 10 100 Can someone show me vba code that would get the feb accrual amount? Is it something like pivottable.PivotFields.PivotItem(<The intersection of Feb, and Accrual??).value? thank you Ps. I tried searching, but could not find anything that I could get to work. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pivot Table Data field
Look in Excel Help at GETPIVOTDATA
-- Regards, Tom Ogilvy "Dan McCollick" wrote: I have an exsisting pivot table that i would like to be able to pull data from a certain intersection point. I.e pivot table Accrual Paid Month Jan 10000 500 Feb 0 200 Mar 10 100 Can someone show me vba code that would get the feb accrual amount? Is it something like pivottable.PivotFields.PivotItem(<The intersection of Feb, and Accrual??).value? thank you Ps. I tried searching, but could not find anything that I could get to work. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pivot Table Data field
Thanks (again) Tom.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table field data | Excel Discussion (Misc queries) | |||
| pivot table data field | Excel Discussion (Misc queries) | |||
| use field data from 1 pivot table in another? | Excel Worksheet Functions | |||
| use field data from 1 pivot table in another? | Excel Worksheet Functions | |||
| Data Field in Pivot Table | Excel Programming | |||
Linear Mode
