Help copying the contents of a changing cell to a another cell but only once and triggered by a change in another cell

[phil_jc]

Ok, here is my problem

I have a feed of live horse odds coming into a spreadsheet and the odds are changing from several hours before the race right up until the end of the race. What I need to do is to copy the odds of each horse at the start of the race. This can be triggered by another cell that changes from being empty to containing the text "in-play" when the race starts.

I know that it can be achieved using circular references but that is a little messy and I am sure that it could be done via VBA but my knowledge of this is limited.

Hope someone can help.

 

[kaos_king]

Hi, I think a sample workbook would help on this one. Where would you like the odds copying to?

I could do some example code, but it would be a lot easier for me if I can see where you have things laid out

 

[phil_jc]

Thanks for the quick reply...

For some reason my posting permissions say "You may not post attachments".. is this because I have only just joined

 

[kaos_king]

More than likely. Are you able to upload to another file sharing service, e.g. google drive, dropbox, filedropper etc?

 

[phil_jc]

https://onedrive.live.com/redir?resid=9244E74BCE32D5B3!139

each horses odds will come in on G 9,11,13,15........49 (based on 20 runners max)

$g$1 will change from blank to "in-play" when the race starts....this is the time when i need to note the current odds on each horse (Start Price)

The resulting prices could be posted on sheet 2 say on A9....A49

 

[phil_jc]

I think I have just stumbled upon an option in the betting software that automatically posts the SP data to excel.....

Thank you very much for taking the time to reply to my problem....i may be back with further questions as I get deeper into this project..

Thanks again

 

[kaos_king]

No worries phil, this was an easy one!