I want to filter my pivot tables based on the month that a user selects on Sheet1 Cell AI.
I have 30 different tabs; each tab contains one pivot table, filtered on the department.
So Sheet 2 is accounting, Sheet 3 is marketing, etc.
Each month the data gets updated, and I want the pivot table to filter data where the period data set equals the value in Sheet1 Cell A1. (Instead of having to go through each of the 30 tabs and change the filter manually).
Sheet1 Cell A1 is a drop down with values 1 through 12.
Is there no way to do this without VBA?
Currently, I have VBA that adds a helper column to my data every time its refreshed that includes a formula to look at the period of each data set and equate to an "Include" or "Exclude" if the value equals or doesnt equal Sheet1 Cell A1.
This helper column is included in each pivot table, so that it accomplishes what I want.
But it just seems like you should be able to do this without VBA.
I have 30 different tabs; each tab contains one pivot table, filtered on the department.
So Sheet 2 is accounting, Sheet 3 is marketing, etc.
Each month the data gets updated, and I want the pivot table to filter data where the period data set equals the value in Sheet1 Cell A1. (Instead of having to go through each of the 30 tabs and change the filter manually).
Sheet1 Cell A1 is a drop down with values 1 through 12.
Is there no way to do this without VBA?
Currently, I have VBA that adds a helper column to my data every time its refreshed that includes a formula to look at the period of each data set and equate to an "Include" or "Exclude" if the value equals or doesnt equal Sheet1 Cell A1.
This helper column is included in each pivot table, so that it accomplishes what I want.
But it just seems like you should be able to do this without VBA.