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