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

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

[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.

__________________
Pixie

"It's worth remembering that profit isn't profit until it's spent off the racecourse." -- Crash

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?

__________________
Never give up on a dream just because of the time it will take to accomplish it. The time will pass anyway.”

― Earl Nightingale

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.

__________________
Never give up on a dream just because of the time it will take to accomplish it. The time will pass anyway.”

― Earl Nightingale