Hi

Bit of a VBA newbie and I need some help. I have a Betfair API program
which can connect with Excel. Their default worksheet (Sheet(1))
displays the runners names and various numerical data, such as current
odds, market volumes etc. I want to record all the data for each
runner at one second intervals and write it to a separate worksheet
for each runner so that I can chart it after the event for analysis.

So far I have managed to write code to establish the number of runners
(1-N), create a sheet for each and rename it as per the runners names,
format it, insert column headings for the data and then link the
current numerical data for that runner in range A1:Y1. It probably
isnt the most efficient code but it works!

Now I need to code to write the current numerical data in range A1:Y1
row by row (A2:Y2, A3:Y3, etc) at one second intervals for each
runners worksheet. I think this would be best achieved with an array
to read and write the data and a loop of some kind combined with a
timer function set to fire at one second intervals. The loop needs to
ignore Sheets(1) and loop through Sheets (2-N). The timer needs to
start as soon as the worksheets 2-N are up and running. Id like the
timer to be killed off programmatically but I cant find a suitable
indicator as yet so I think that would have to be done manually.

I really need help with this bit as its the whole point of the
exercise and Im afraid to write code that lands me in an endless loop
or only loops on one runner.

Look forward to your responses.