Dear all:
Can the selection of drop-down variables in a Pivot Table be done from a sheet other than the sheet on which Pivot table exists. I pick values from the sheet on which Pivot Table exists onto another sheet for a neat analysis. The reason I want such an option is my pivot table is very huge. & I want to know a way to avoid going back-forth to the sheets to select / modify a variable and see the result on the other analysis sheet. I want to be able to do this while staying on the analysis sheet itself. Is it possible ?
thank you