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:
> 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 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 haven’t been able to
> figure out. =(
>
>
|
Similar Threads
