Dynamically Changing Pivot Data Fields with a Macro
 

Howdy,

I am working on a rolling forecast. Every month I need to drop off one
month and add another. My source data is in a list (using excel 2003),
and I have a macro to add the next month within the list, and then
refresh the pivot table so that the information is available for the
pivot.

My need is to have the pivot show only the last two months, in
addition to the upcoming twelve. For example: Right now if I am doing
the July 08 forecast I need to go to the pivot and manually drop April
08, and add June 09. I would like to program a Macro to read the
source data headers and only put in the 14 months that I need. Any
help would be awesome.

Thanks in advance.