Thanks for your reply Stugots. Yes I've been able to source some codes from the net to speed things up. About the only one I'm still having to manually every race is when I've applied a conditional format (colour font red) to identify the winner in a range. But when I go to transpose the range the formatting doesn't come with it. So I have to manually click on the winner and format it red in every race. can you help?
Cheers RP