Help with Get and keep a value in excel before going In Play

[MetallicIan]

I'm trying to figure out how to put the final known value of "Total amount matched" on the first horse just before the race goes In Play from cell P5 into another cell (e.g. cell AJ5) so that it does not increase further when the race goes In Play.

Does anyone know how to write a spreadsheet cell formula to do this?

Or if it is too complex to put into a cell formula, a macro?

Thanks,

Ian.

[MetallicIan]

Not to worry, I've solved it myself thanks.

[Roger]

Not to worry, I've solved it myself thanks.

So could you help us by telling how you did it, please?