Locking in data of a bet.

[cara]

Hi

Is there any way of locking in the data on which a bet is made. The bet is automatically selected but once the race is over, the data disappears. I would like to retain the row of data for the bet that was made.

While I'm at it, Is the "Bet Ref" a number or text. If I want to include a bet ref cell in a formula do I say, IF(A1>0, or do I say IF(A1="",


Thanx

cara

[GeorgeUK]

You'll be sick of hearing from me.

To have a "bet history" the only way i know of is to write code that will copy the data to another sheet - probably when the race becomes suspended (after being inplay). I'm afraid i haven't written any code to do that.

For the Bet REf, it may depend on whether the bet is partially filled (i think)
i would suggest using =""
so that there is either a bet ref or there isn't.

[cara]

Never George

I didn't write directly to you as I thought that you would be getting sick of me. After all we are probably the only 2 on here that know of Hilda and Evadne.

If it is code then I'm afraid that lets me out. As you will have already gathered from our other chats.

Thanx for the usual prompt reply.

Cara