I have several pivot tables linked to data cubes. Each has year, quarter, and month as well as data for the past ten years or so. I often generate reports based on these tables, but only the past 3 years (e.g. 2011, 2010, 2009) and the current year only up to the current month and quarter (e.g. Q3 2011 and August).
I'm still a VBA beginner I am trying to figure out how to write some VBA code to automatically filter the dates so I don't have to go through so many reports and manually do it. I'm trying to figure out how to do it on one table and then will repeat for the others, but am not having much luck making progress. Any ideas of how to meet my goals?
I'm still a VBA beginner I am trying to figure out how to write some VBA code to automatically filter the dates so I don't have to go through so many reports and manually do it. I'm trying to figure out how to do it on one table and then will repeat for the others, but am not having much luck making progress. Any ideas of how to meet my goals?
