View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
T. Jenkins T. Jenkins is offline
external usenet poster
 
Posts: 24
Default 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