Help a Newbie! Using GETPIVOTDATA formula!

[certain_death]

Hi all
Can anyone help please??

I have a pivot table in one sheet and a summary sheet in an exce
workbook.

In my summary sheet I want to select anything in column D, and displa
it on my summary sheet.

Am looking at GETPIVOTDATA formula but cant seem to fathom it out.

Can anyone explain to me how it works and what is the best suggestion?

Many thanks
:

 

[Guest]

See Debra Dalgleish's instructions:
http://www.contextures.com/xlPivot06.html

You can also use direct references to cells in the pivot table.

Hope this helps,

Hutch