To start with, I have a fair amount of experience in Excel, but very little to no experience with macros/VBA
Essentially, I have an excel workbook that has a pivot table connected to a data source that has lookups/matchbacks based on a separate pivot table that's controlled by a slicer. Essentially, I need to set up a VBA code that will update the particular pivot table that’s connected to the data source when my slicer updates the pivot table that adjusts the lookups/matchbacks in the data source. For additional context, the slicer controls a separate pivot table that changes the values displayed by the cells in my data source, but it does not actually change the contents of the cells. The pivot table I need to have updated displays a percentage based on whether the cells in my data source display a "1" or a "0". As it currently sits, I have to refresh the data every time the slicer is changed, and I’d like to have it update automatically every time I change the slicer.
I have searched up and down the internet for a solution, but everything I find shows a code for updating a pivot table when the data source has values that actually change, but not references that just change what the cells display.
Any help is appreciated
Essentially, I have an excel workbook that has a pivot table connected to a data source that has lookups/matchbacks based on a separate pivot table that's controlled by a slicer. Essentially, I need to set up a VBA code that will update the particular pivot table that’s connected to the data source when my slicer updates the pivot table that adjusts the lookups/matchbacks in the data source. For additional context, the slicer controls a separate pivot table that changes the values displayed by the cells in my data source, but it does not actually change the contents of the cells. The pivot table I need to have updated displays a percentage based on whether the cells in my data source display a "1" or a "0". As it currently sits, I have to refresh the data every time the slicer is changed, and I’d like to have it update automatically every time I change the slicer.
I have searched up and down the internet for a solution, but everything I find shows a code for updating a pivot table when the data source has values that actually change, but not references that just change what the cells display.
Any help is appreciated
