Hi,
I would like to reference a cell in a pivot table. In a different worksheet in cell H5 I'd like to simply say =(U5).
U5 is the cell in Pivot table and contains the number 128.
I then want to drag this formula down to reference U6,U7,U8 etc
However when I do this I only get the value in cell U5(128) all the way down.
My formula looks like -> =GETPIVOTDATA("Visits_NoHrs",Sheet2!$A$3,"CarerName","Aislle")
Is there a way around this?
Gerry
I would like to reference a cell in a pivot table. In a different worksheet in cell H5 I'd like to simply say =(U5).
U5 is the cell in Pivot table and contains the number 128.
I then want to drag this formula down to reference U6,U7,U8 etc
However when I do this I only get the value in cell U5(128) all the way down.
My formula looks like -> =GETPIVOTDATA("Visits_NoHrs",Sheet2!$A$3,"CarerName","Aislle")
Is there a way around this?
Gerry
Last edited: