I am not sure if this is possible, but I am hoping it is. I a beginner with VBA, so I am not sure where to even begin. I have a pivot table with a slicer. The pivot table has several columns to the right of it that are calculations based on the pivot table results to the left. One of the calculated fields is dependent on how many items are selected on one of the slicers. At the moment, I have to manually change a value in a cell to match how many items I have selected in the slicer.
For example, if I choose only 3 items in the slicer, I have to change cell C4 to 3, so that my calculations are correct. If I choose 1 item, I have to update cell c4 again. This is a report I created to be used by others, and I fear they will forget to update C4 when running through different scenarios with the slicer.
I am hoping that a simple piece of VBA code will tell cell C4 to update with the number of items that were selected on the slicer, so that the calculated fields will update automatically.
Any help/suggestions would be greatly appreciated.
Thanks!
Bookmarks