Cycling Through Pivot Field
I want to create a macro that cycles through a Year-Month field in a pivot
table, allowing me to easily update a chart for different years and months.
In other words, I'd like to be able to click an up or down button to update a
pivot table and chart to show a set of data for different year-months. I'm
also considering just a single "start" button to cycle through all
year-months at one time.
Can anyone offer suggestions on how to do this?
Thanks,
Todd
|