hi all.

I am in the middle of designing a new target bet sheet, available for all on request, just ask.

It is a simple thing which tracks the bets, it shows bet number up to 100, a target that we are after, the divisor, bet amount, div paid, profit loss, venue, horse etc.

I have done it all except, this is where i need a push.

I have a divisor in column c, eg 64. i need this to remain the same if the bet looses, BUT, i need it to drop by "div paid-1" which is coulmn f.
I have gone through the help files but cant find referance to it,

And if some one can tell me how to "lock" some of the columns,..not all of them so the info cant be changed ?

IM LOST !

Thanks for any help.