Hi!

I am doing a rolling forecasting of an income margin of a certain product. I have all the data in one table with column names like September 2009, October 2009 etc.

I am summarizing the data with a pivot table and then I have a "Sum of September 2009", "Sum of October 2009" etc. values as columns.

I have forecasting date and if it is for example 1.9.2009 the column names in my data table are starting from September 2009 to August 2010 (if I am doing the forecasting for a year).

If I change the forecasting date to 1.10.2009 and refresh my pivot table I have a "Sum of October 2009" as a first column. So it is working as it should so far. However, the last column is still "Sum of August 2010" which it was before refreshing. So know I have data for only 11 months because the last column should be "Sum of September 2010".

How could I so that when I am refreshing the pivot table, Excel would understand to roll the months. So that I would always have 12 months of data in my pivot table..?? Do I have to do it with VBA somehow?? To check what is the first column in my pivot table and then get the next 12 months as columns..

Thanks for any help!

Br,
John