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

"Vince" wrote:

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.

Use absolute references ...

So, to reference cell D8 and ensure that this does not alter, use =$D$8


"Vince" wrote in message
...
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.