excel help

[knot]

Hello, i would like to transfer the last matched price if below 1.20 from sheet1 to sheet2. i know how to link the sheets but i would like to save the info from sheet 1 when a new race is loaded 1 min before the off. so if a cell in sheet 1 is below 1.20 then this is shown in sheet 2, but saved in sheet 2, even when sheet 1 is reloaded. hope this makes sense .

[knot]

Hello

[GeorgeUK]

Hi knot - seems a bit quiet in here

I won't be able to look at anything until after the weekend, but maybe you can walk through an example so that others have a clear idea of what you mean. I think i get it - you want to see all the horses that went to odds of 1.2 or less for a race displayed on sheet2 but with that horses lowest odds recordedas well?

If so, you need some code in a worksheet_change event that will:
put the race name in sheet2 when any horses <=1.2
record the horse name beside the race name
then record the odds next to that.

The code will also need to check each time that the horse that is <= 1.2 is not already listed and if it is, that the current odds are less than those on sheet2 for that horse, otherwise it shouldn't be recorded.

It should be doable, but like is said - i can't look at it for a few days.

good luck

[knot]

Thanks George i have sent a PM.