Euro5
asked on
vba change pivot dates
I have a pivot table and want to change the date range each month.
The dates this month are March & April, but next month they would be April and May.
The pivots will always be same name and place in the workbook.
Can anyone help me do this using VBA? Thank you!
The dates this month are March & April, but next month they would be April and May.
The pivots will always be same name and place in the workbook.
Can anyone help me do this using VBA? Thank you!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The VBA element can just include a line to Refresh the Pivot with the filter already applied
ASKER
So create a column that is yes/no for the question date was last month?
And use that as the filter? I think I get it!!
Let me try that Rob!
And use that as the filter? I think I get it!!
Let me try that Rob!
ASKER