Need help generating a table

[Frick]

I need some help trying to generate a matrix, I think, or maybe just a table.

For example:

In B8:B127 = Months 1 through 120
Column C8:C127 = a #
Colums D through M represents production levels

What I want to be able to do is when I enter a number in say C10=2 then a table is generated returning the following:
D10:D21 2 is entered in each cell
E22:E33 2 is entered in each cell
F34:F45 2 is entered in each cell
G46:G57 2 is entered in each cell
H58:H69 2 is entered in each cell

This table continues out to Col M.

Once the table is generated I need to be able to generate additional tables and add them all together.

Is this possible?

 

[Frick]

Oaktree... I tried the formula and it works except that it enters the result one month later then it should. With 2 entered into C10, the expected well retierment month 10 years later would be month 122 which is row 130 so N130 should return -2. This is not the case. Cell N131 returns the -2. Am I doing something wrong here?

 

[Oaktree]

Hmm. Maybe your formula started in row 7 before you copied down?
If

C10 = 2

and

N130=IF(ROW()-ROW($E$7)<(12*(COLUMN()-COLUMN($D$8))+1),"N/A",-OFFSET(C130,-12*(COLUMN()-COLUMN($D$8)),0))

I'm getting N130 to be -2 as expected