I've downloaded the NCAA 2006 Mens basketball tracker. It only allows you to
track 5 peoples picks. I want to expand this to 20. Everything copies ok,
except the cell references. For the first game, it needs to reference cell
d8 on the first sheet, the second game is d12, etc. when i copy the
formulas, it automattically changes the d to an f. i need all of the
formulas on the columns i've added to remain the same as the five original.
I've tried paste special, but to no avail. I really don't want to change
over 100 cells, to run my tournament. Any help would be appreciated.
make the formula an absolute refrence,,
$d8
instead of d8
quot;Vincequot; wrote:
gt; I've downloaded the NCAA 2006 Mens basketball tracker. It only allows you to
gt; track 5 peoples picks. I want to expand this to 20. Everything copies ok,
gt; except the cell references. For the first game, it needs to reference cell
gt; d8 on the first sheet, the second game is d12, etc. when i copy the
gt; formulas, it automattically changes the d to an f. i need all of the
gt; formulas on the columns i've added to remain the same as the five original.
gt; I've tried paste special, but to no avail. I really don't want to change
gt; over 100 cells, to run my tournament. Any help would be appreciated.
Use absolute references ...
So, to reference cell D8 and ensure that this does not alter, use =$D$8quot;Vincequot; gt; wrote in message
...
gt; I've downloaded the NCAA 2006 Mens basketball tracker. It only allows you
gt; to
gt; track 5 peoples picks. I want to expand this to 20. Everything copies
gt; ok,
gt; except the cell references. For the first game, it needs to reference
gt; cell
gt; d8 on the first sheet, the second game is d12, etc. when i copy the
gt; formulas, it automattically changes the d to an f. i need all of the
gt; formulas on the columns i've added to remain the same as the five
gt; original.
gt; I've tried paste special, but to no avail. I really don't want to change
gt; over 100 cells, to run my tournament. Any help would be appreciated.
留言列表
