Prev: when i save a file that i have worked on, excel7 closes down work.
Next: Creating a list from a different worksheet
From: mbardon on 11 Feb 2010 05:01
Hi all,

I want to be able to get the cell reference (in the format A1) of a
GETPIVOTDATA reference. For example:

=(GETPIVOTDATA("Sum of Qty",'$A$5,"Customer Name","ABC Company"))

pulls data from a corresponding cell in the table. That reference is A10 but
I want to get this from the actual GETPIVOTDATA reference itself. Is this
possible?

Regards

Morgan
 | 
Pages: 1
Prev: when i save a file that i have worked on, excel7 closes down work.
Next: Creating a list from a different worksheet