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.

[Tom Ogilvy]

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.
>
>

[Dan McCollick]

Thanks (again) Tom.