Capture forecast volume from wk1 to wk8

[cks1026]

Hi all expert,

I need help.

I got 400 products with 4 type of forecast, which I need to capture every week 1 to week 8 for every week forecast submission.
Every week I would have different week 1 to week 8 forecast rolling as we move forward.
In short, in one year time, I would have 52 forecast submission, for the 400 products, for week 1 and week 8 rolling.

How can I capture this in excel spreadsheet, so that I can compare against actual....?

Appreciate all the expert advice...

Example as below:-

(Assuming now wk52, capture week 1 to week 8)

Product A wk1 wk2 wk3 wk4 wk5 wk6 wk7 wk8
Forecast A = 100, 200, 300, 400, 500, 600, 700, 800
Forecast B = 110, 120, 130, 140, 150, 160, 170, 180
Forecast C = 100, 0, 0, 100, 0, 0, 0, 100
Forecast D = 10, 20, 30, 40, 50, 60, 70, 80

Then next week wk2, wk3, wk4, wk5, wk6, wk7, wk8, wk9 with different number.

How can I snapshot every forecast submission, and snapshot 8 weeks rolling forecast, and when I have actual sales coming in, I can call out all the 8 week rolling forecast for all the 8 week submission.

Let me know if this require clarification.

Thanks

Regards
cks1026

[canapone]

Hi

a first answer in the attachment, try to change value in cell A9 (first scenario is 0)

In B9 to be copied across

=INDEX($B$1:$AC$8,ROWS($1:1),COLUMNS($A:A)+$A$9)

A small sample file could be helpful.

Regards