2nd June 2007, 10:48 PM
|
Member
|
|
Join Date: Jan 2006
Posts: 35
|
|
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
|