T
Takeadoe
=GETPIVOTDATA("PrehuntTotal",'pvt prehunt ASMtotal'!$A$3,"COUNTY",$AF
$2)
Those familiar with the GetPivotData function know that "pvt prehunt
ASMtotal" is the name of the pivot table and "PrehuntTotal" is the
variable name - the data I'm interested in. The value for "County" is
set dynamically. The user selects county from a drop down list. The
choice is placed in Cell $AF$2. My question for the group is this -
would there be a way to set the variable name the same way that the
value of county is set so that the user can select the variable of
interest on the fly?
Very best,
Mike
$2)
Those familiar with the GetPivotData function know that "pvt prehunt
ASMtotal" is the name of the pivot table and "PrehuntTotal" is the
variable name - the data I'm interested in. The value for "County" is
set dynamically. The user selects county from a drop down list. The
choice is placed in Cell $AF$2. My question for the group is this -
would there be a way to set the variable name the same way that the
value of county is set so that the user can select the variable of
interest on the fly?
Very best,
Mike