Im 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 jumping based 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 havent been able to
figure out. =(