First off, I would like to say that I'm an excel macro and VBA rookie. I am trying to create a macro that will link multiple pivot tables together so that when one of the filters is changed, all of the other filters will change with it.
Specifically, I have a large data table that is connected to about 100 different pivot tables. These pivot tables each have different filters for the various columns in the data table.
The "month" filter is one of these filters in the pivot tables.
I would like to have a macro that would instantly change the "month" filter in all of the pivot tables to the same month.
I have come across many other posts explaining methods to do this, which I have failed to replicate. I am looking for the simplest way possible to do this.
If anyone could recommend a good website explaining the basics of VBA, that would also be helpful.