Hello everyone
I need your help. I have excel experience, but I'm far from a pro.
Is there a way you can refer to different cells when a slicer filter is applied?
Eg. the slicer filters January and a certain cell shows the value of January, but when the slicer filter is set to July in the same cell it should show the value of July. (See pictures).
I doubt this is possible with a function, but maybe it is with VBA?
Would be a great help if someone knew how to code this
Thanks!
I need your help. I have excel experience, but I'm far from a pro.
Is there a way you can refer to different cells when a slicer filter is applied?
Eg. the slicer filters January and a certain cell shows the value of January, but when the slicer filter is set to July in the same cell it should show the value of July. (See pictures).
I doubt this is possible with a function, but maybe it is with VBA?
Would be a great help if someone knew how to code this
Thanks!