VBA question

[London_Calling]

Ev'nin all,

I’m really struggling for the right word here,please bear with me.

Say I’m laying two runners at different odds but for the same potential loss. In, say Column z, I’d like those two runners to have in their relevant row an A or B depending on which of them was laid at the lowest odds (an A in this cell) and which was laid at the higher odds (a B in this cell).

I can do that with formulas (using column V or W via Bet Assistant), the problem comes when other bets are introduced and the numbers change in column V or W - A is no longer the A and B is no longer the B and I need the initial A and B to stay as A and B even after changes occur in columns V or W.

I guess this will probably be a VBA solution, any ideas?

Cheers

[London_Calling]

Just to say . . . in theory I did find an answer to this by recording a macro of copy + Paste Special and put that in an If-Then VBA structure - I'll find out for sure this afternoon . . .