Hi.

I'm trying to make a table (which is full of equations and references to different places) to use as a template for moisture and temperature calculations in walls. Since different types of walls have different numbers of material layers in them I would like to have the ability to in the beginning of the document enter the number of layers in the construction and have excel automatically adjust the table without messing up cell references so that it looks more nice and tidy. Is this possible in excel?

I have a picture to illustrate what I want excel to achieve.

Table excel.jpg