I have a macro that was working fine untill I tried to change the name of the sheets. I changed the names back again, but the macro would no longer work.
Also I would like the macro to list the Trainers on the final list according to highest average to lowest.
Also I would like there to be no zero's (just blank) if the trainer had no entry in the race. (Last sheet)
And finally, I would like the macro to clear the contents of sheet 1 and sheet 2, after data has been used.