Dear All,
I am a bit of a novice at all this. I have tried recording some macros for some things successfully but others I just can't work out how to do!

What I want to do is copy horserace results data from the timeform betfair website and import it straight into a useable format in excel.

I have tried doing a new web query and importing the table but the format is totally out and I can't work out how to get it into the format I need!!

As an example, I would like to get this data: http://form.timeform.betfair.com/rac...1.30.1140328.1

into an excel sheet in this format:
https://www.dropbox.com/s/s3krl2a8d60rxjb/Example.xlsx

and then repeat the process for another race and add the data to the same sheet...

And I am using excel for Mac (although I could use excel for windows via parallels but its a bit of a hassle!)

Thanks all!

Matt