Pivot Table Data field

[Dan McCollick]

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.

 

[Guest]

Look in Excel Help at GETPIVOTDATA

 

[Dan McCollick]

Thanks (again) Tom.