Quote Originally Posted by Aflatoon
If you actually have a pivot table (unlike your sample!) then GETPIVOTDATA may well do what you need
I do have a pivottable on sheet1...I just copied/pasted a snippet of data only onto the worksheet.

How does GETPIVOTDATA work?