Hi Guys,
I have a spreadsheet linked to live horse racing odds which changes frequently. I want to capture a set of odds at 10 secs before the race starts for each horse selected and display those odds in a new cell for each runner. I don't want the new cells to change despite the live data updating. What VBA code is needed for the time and the new cells. Can anyone write this code to help implement the above strategy. Any help would be much appreciated.
EB