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:
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!)