I've looked at a few other posts on this subject but can't seem to get them to work as I need, so would appreciate any help you could provide.
On my spreadsheet, there are several locked sheets (no passwords) with just a few cells on the first sheet to enter scores during a golf competition.
The "Results" sheet shows leaders names and scores, I want to display on a big TV screen and if possible, set it to display the first 5 places (There is a macro to sort the table), then automatically scroll positions 6 onwards.
Hope that makes sense and appreciate any guidance.
On my spreadsheet, there are several locked sheets (no passwords) with just a few cells on the first sheet to enter scores during a golf competition.
The "Results" sheet shows leaders names and scores, I want to display on a big TV screen and if possible, set it to display the first 5 places (There is a macro to sort the table), then automatically scroll positions 6 onwards.
Hope that makes sense and appreciate any guidance.
