I'm trying to set up a spreadsheet that is a 2 year rolling forecast.
The raw data is either imported or manually entered into separate
worksheets. I then take this data and summarise in another worksheet.
The problem I have is that the forecast summary worksheet is static & I
need it to be dynamic.

For example,

Month: Jan Feb Mar Apr May
Sales: 50 75 80 85 90

As the month changes then the rolling forecast should look like:

Month: Feb Mar Apr May Jun
Sales: 75 80 85 90 100
and so on ......

I can get the month value to dynamically change when the month changes,
but I cannot get the data in the columns to alter in line with the
month.

Does anyone know how I can tie the summarised data to the rolling
month?

FB


--
fergusbell
------------------------------------------------------------------------
fergusbell's Profile: http://www.excelforum.com/member.php...o&userid=36704
View this thread: http://www.excelforum.com/showthread...hreadid=564614