version 2 is completed -

* results are now numericals
* win divs ranked
* scratchings fixed
* abandoned races noted
* blank row between venues for easier cut/paste
* venue list displayed on front page

Attached Files

Tattsbet Results v2.xlsm (81.6 KB, 766 views)

Hi Dennis, if you move the screenupdating line right to the end as below the code runs much quicker, for example yesterdays results completes in 20 seconds.



TransposeRaceCodes
Application.ScreenUpdating = True
End Sub

Thanks mate, flying now...

A fix for abandoned - in the LoadRaceDetails macro two thirds of the way down after ' Abandoned the 9 should be replaced with a 4.

"=IF(RC[-5]<>"""",IF(R1C[9]=""ABANDONED"",""ABD"",""""),"""")"

should be -

"=IF(RC[-5]<>"""",IF(R1C[4]=""ABANDONED"",""ABD"",""""),"""")"


I'm using my laptop and quite often forget the numlock key and when I type a number it doesn't appear :-[

attached is the one i use.
just add the date in sheet 3 b1,c1,&d1 and some field info comes out in sheet 1 and the results in sheet 4.

the choose the "both for date" button

update as you wish

good luck
aussie

Attached Files

tatts xml tester.xlsm (74.9 KB, 755 views)