Hi Domenic

ok, glad you asked, i had 1 error within what i sent you before.

I have rebuild the code to show the output for both race 1 and 2.

Basically, i wish to account for the issues when there is not 6 runners.

and then

transpose the data i suppose. at least thats what i would be trying to do if adjusting it after it was downloaded.

Thanks for looking at the domenic, although i really wonder if it is possible?

Still cannot believe how fast the the data arrives, not to mention how clean it is to run.

Code:

Sub output_layout_example()
''''''''''race 1
Range("a1") = "sheffield"
Range("b1") = "13/05/2017"
Range("c1") = "19:25"
Range("d1") = "A4"
Range("e1") = "Unique Nero"
Range("f1") = "Valiant Striker"
Range("g1") = "Breakthenews"
Range("h1") = "Glenbuck Rose"
Range("i1") = "Geelo Racer"
Range("j1") = "Yahoo Angela"
Range("k1") = "2"
Range("l1") = "1"
Range("m1") = "3"
Range("n1") = "6"
Range("o1") = "5"
Range("p1") = "4"
Range("q1") = "4/1 , text not date"
Range("r1") = "3/1, text not date"
Range("s1") = "6/1, text not date"
Range("t1") = "4/1, text not date"
Range("u1") = "2/1F, text not date"
Range("v1") = "3/1, text not date"
'''''''''''''''''race 2
Range("a2") = "sheffield"
Range("b2") = "13/05/2017"
Range("c2") = "19:40"
Range("d2") = "D2"
Range("e2") = "Dash Away Wink"
Range("f2") = "Night Of Thunder"
Range("g2") = "Lightfoot Niamh"
Range("h2") = "Its Jack"
Range("i2") = ""
Range("j2") = "Swift Darius"
Range("k2") = "2"
Range("l2") = "5"
Range("m2") = "4"
Range("n2") = "1"
Range("o2") = ""
Range("p2") = "3"
Range("q2") = "3/1 , text not date"
Range("r2") = "4/1, text not date"
Range("s2") = "9/2, text not date"
Range("t2") = "9/4, text not date"
Range("u2") = ""
Range("v2") = "7/4F, text not date"
' when a runner is missing, the data would be blank for that trap number
'"track", "grade", "date", "datetime", "essential greyhound" 1-6(in trap order if possible), "first essential fin" 1-6, "sp" 1-6
End Sub

## Like this thread? Share it with others