Block Equation Copy

[Lunch]

I’m looking to copy a block of equations and stretch them down the
page. I am dealing with six cells, two cells are static, two cells are
dynamic, I then have a few cells after the block which are empty. The
problem I am having is that when I drag the block down the cells are
not “generating†in a block format. The equation is jumpingbased on
the number not based on the block but rather the the number of cells
it has moved down……….any help would be great.

Here is what the cells would look like:

A204 =$A$1
A205 =$D7
A206 =$A151
A207 =$A$3
A208 (blank)
A209 (blank)

How they should look when I drag the equations down from A10:A15.
A210 =$A$1
A211 = $D8
A212 =$A152
A213 =$A$3
A214 (blank)
A215 (blank)

How they ACTUALLY look.
A210 =$A$1
A211 = $D15 Added the numbers of rows from previoius
A212 =$A159 Added the numbers of rows from previoius
A213 =$A$3
A214 (blank)
A215 (blank)

There has to be a simple way to do this but I haven’t been able to
figure out. =(

 

[Guest]

hi,
and i don't think your are going to. cell references don't understand being
part of a "block". they only understand number of rows and number of columns.
your "block" would work if you moved the "block" right one column or
transpose the data into a row and move the "block" down one row.

regards
FSt1