Hello All,
I have a formula and I want to change a part of that formula at the click of a 'button'!
For discussion say the formula is - =COUNTIFS(GPR_Data!$B:$B,"G",GPR_Data!Y:Y,">0")
The part I wish to change is “GPR_Data!Y:Y”.
On click I wish that part to change to “GPR_Data!Z:Z” and the...