View Single Post
  #10  
Old 2nd June 2007, 11:48 PM
Sparky12 Sparky12 is offline
Member
 
Join Date: Jan 2006
Posts: 35
Default

Many thanks Shaun. Prior to seeing your post I went with the ultra simple option and cut and paste the data directly into Excel from the VFG website. I then ran the "text to columns" utility which treated the data as delimited text and broke the data into colums in an almost identical manner to your own columns . I've rated a few races now (using my own system which looks quite similar to yours) and it seems to work OK but I'll keep checking in case it comes unstuck. I've recorded a macro to run the formatting of the imported data and make a few other changes and I can be done in less than 2 mins. Again, this is all thanks to your formulas!

Cheers
Reply With Quote