Each Saturday I concentrate on the 5 metro meetings and I use different columns within excel with ratings from 1 up to however many horses in the race. Example like the average prizemoney order. After scratchings I find it time consuming reordering the column ratings. Is there a way to do this automatically without changing the tab order of the horses in each race. I have the five meetings on one sheet so if it could be done to all five meetings at once that would be even better.

Thanks in advance
Twodogs