I already created other Drop down lists that action macros depending on the month and the year.
What the Macro basically do is the following: After I select a certain entry from the drop down list, it goes to 30 different pivot tables and changes the field to that value.
So for example, if I choose the month “2”, this activates a Macro that goes to those 30 pivots and changes it to month “2”.
So what I had to do was to create 12 Macros, one for each month, and then create a Private Sub Worksheet_Change in the Worksheet Module
This is the code I am using to have the macros activated based on the year and month:
Now, this is where it gets a bit tricky for me, I have a 3rd drop down list that is based on a dependant Named range.
This dependant Named range feeds from a pivot Table and the values on this list change depending on the year or the month I select previously,
So the values on the drop down list change based on that info.
Plus, there will be future new entries that are not currently present on the data at the moment so I can’t create a fixed number of Macros, like I could with the “Month” entries for example.
What I would like to be able to do is:
When I select an entry from this drop down list, I would like a macro to activate and change the field on those 30 Pivots, based on the entry itself, so this would be a flexible value.
So on the Macro that changes the pivots, I can´t name the value itself, but rather the value contained on that cell.
I hope it is clear what I am asking.
It makes sense to me but I know that sometimes when explaining to others, it might not.