Hello all ,
I am hoping to get functions or a macro that can give me the 7 x pieces of data I have in cols BK2:BO2
The main problem I have is col BJ always varies in field size .
There could be anywhere from 4 horses in a race up to 14 . This is very random .
The seven results are all taken from below the words Dividends and Times .
The mile rate I have changed to format of time so I can sort from lowest to highest times .
The trick I believe is to obtain the results from below the two words mentioned above or at least getting the whole
line , example BJ7 and BJ11 then splitting these .
Any ideas would be great .
Thanks .
Bookmarks