Is there a way I can do a automatic sort, every minute for example. My final results of a sporting competition are on sheet 9. This sheet is displayed on a separate screen (for the crowds to see). The results are ranked and this changes as new results come in.
At present I need to go to sheet 9, highlight relevant area, and do a sort by column x.
I'd like this to happen automatically, we would enter data in sheets 1-8 and sheet 9 would show the results in ranked order. Updated at regular intervals.
Richard
At present I need to go to sheet 9, highlight relevant area, and do a sort by column x.
I'd like this to happen automatically, we would enter data in sheets 1-8 and sheet 9 would show the results in ranked order. Updated at regular intervals.
Richard