Hi all,
I have been trying to make my worksheets more dynamic for which I believe applying VBA is necessary in my specification situation. Unfortunately I consider myself somewhat a beginner in VBA, i.e. I understand the code by reading it but I am not able to reproduce the code itself. Hope you guys can help.
I want the pivottable filters to refresh based on a cell value and select that cell value. Code I found online has only been able to reproduce it when the code is manually entered ( Filtering Pivot Table Based on a Cell Value ) . When I include a formula in this same cell reproducing a value from another worksheet, no refreshing of the filters/pivottable occurs, which is probably due to the code. Looking for a fix in the code or workaround.
Situation is as follows,
Worksheet: "Var code".
Cell Range to select: "o5" (This cell includes the formula lookup)
Field/Category to change: "Period"
Pivottable name: "PivotTableVAR"
Thanks!
I have been trying to make my worksheets more dynamic for which I believe applying VBA is necessary in my specification situation. Unfortunately I consider myself somewhat a beginner in VBA, i.e. I understand the code by reading it but I am not able to reproduce the code itself. Hope you guys can help.
I want the pivottable filters to refresh based on a cell value and select that cell value. Code I found online has only been able to reproduce it when the code is manually entered ( Filtering Pivot Table Based on a Cell Value ) . When I include a formula in this same cell reproducing a value from another worksheet, no refreshing of the filters/pivottable occurs, which is probably due to the code. Looking for a fix in the code or workaround.
Situation is as follows,
Worksheet: "Var code".
Cell Range to select: "o5" (This cell includes the formula lookup)
Field/Category to change: "Period"
Pivottable name: "PivotTableVAR"
Thanks!