Where it should have the unitab rating just change the first part of formula to $AF$3 not $AG$3 then copy down.

[QUOTE=Vortech]

Trying my luck overseas

Durben 3 - 11 - SCR
Lingfield 2 - 5 - SCR
York 1 - 11 - 1st 8.00
York 4 - 3 - 1st 1.20
York 6 - 11 - Unplaced

Vortech

I have a excel file i use to consolidate data from R&S, then i paste it into a microsoft Access Database- you copy the data from R&S site then i have a macro button that pastes the data into the excel sheet. if you have anything in particular that you are after, i may be able to assist with what i have and modify to what you are after.
I currently get the Nuerals, Worksheet(DS ODDS) and Ratings pages

Pete

Thanks Pete

Basically I have a log in to R&S and have a customised form guide which allows me to filter my 6 variables.

From there I have to manually load each meeting and check which horse gets all the ticks.

The filters include the CP rating out of Neurals, Don Scott FR, DLS, Career Starts, Barrier and track condition.

I would like to have a Macro dump all the data from all the meetings into a Excel sheet. I don't think its possible to list the selections based on my criteria.

Also I assume the DS FR and neurals change after scratchings?

It's the quiet ones you've got to look out for Vortech. I like your Twitter idea.

Selections today

QR 1 h3
QR 6 h7
PR 4 h1
NR 7 h4
AR 7 h2

Awesome Shaun, thanks.

I don't suppose anyone has any stats for the other neural categories like CF, TIM, JA, TA, JT, CRS, etc?

These are based on tatts prices. Results since August 2011 as per most of my data.

Disregard slightly wrong SQL.

Some of these races have more then 1 as the top, for example JA, JT, TA. You might get 3 or more horses with the same figure.

No worries UB.