Thanks - that helps!
RADO


"Dick Kusleika" wrote in message
...
RADO

If you want the total of SubCat A, then you would use

=GETPIVOTDATA(A1,"Category 1 Subcategory A")

If you had a row for RADO and you wanted RADO's numbers for Subcategory B,
you would use

=GETPIVOTDATA(A1,"RADO Category 1 Subcategory A")

The A1 is any cell that's in the pivot tables. The name portion is like a
path to the data separated by spaces.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"RADO" wrote in message
...
I have a pivot table (excel 2002) with several column fields. It looks
like
this:
Category 1
Subcategory A Subcategory B
.....

I would like to be extract data from one column, say Subcategory B,
programmatically. How can I do that?

I tried to use GetPivotData, but could not figure out how it works.

Thanks -

RADO