Block Equation Copy
 

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. =(

Block Equation Copy
 

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

"Lunch" wrote:

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. =(