The GetPivotData function can return the data and totals from the pivot
table, but not the field item text.

You can link to a cell that contains a part number, e.g. =B8


Vikram Dhemare wrote:
Hi Friends,

I have Pivot table something like below mentioned :
Data
CHILD PART NO. FG PART NO. Sum of TOTAL
1010051 ATM0609 11556
1010160 ATM0415 144
PTM0606 2792
PTM0607 3800
1010161 ATM0412 6551
1010162 ATM0415 144
PTM0606 2792
PTM0607 3800

Now, I wish to pull the data "FG PART NO." (not the sum of total) as a
result. Is this possible by using "getpivotdata" function.

Hope u understood my question.
Thanks in advance.

Vikram P. Dhemare


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html