Lee McMahon
New Member
- Joined
- Aug 13, 2010
- Messages
- 1
Hi,
This is my first post on this forum, but I have used it maytimes before with great sucess. So thank you!!
My problem is this:
I have 3 pivot tables which contain different data, the onr field they have in common is a month field.
I have written a set of macros that filter the 3 pivots based on an input month. This works fine.
The problem I have is that one of the pivots might not have that particular month availble as a filter. Hence my macro fails.
What I want is for the pivot that does not have the availble month to reset to zero values, and when I run a different month it updates again with the relevant data.
Is this possible???
This is my first post on this forum, but I have used it maytimes before with great sucess. So thank you!!
My problem is this:
I have 3 pivot tables which contain different data, the onr field they have in common is a month field.
I have written a set of macros that filter the 3 pivots based on an input month. This works fine.
The problem I have is that one of the pivots might not have that particular month availble as a filter. Hence my macro fails.
What I want is for the pivot that does not have the availble month to reset to zero values, and when I run a different month it updates again with the relevant data.
Is this possible???
