I would like to make a Eurovision style leaderboard in E
xcel that updates the position of items on the leaderboard as the score is typed.
For example:
Country Flag is in B2 to B14 and E2 to E14
Country Name is in C2 to C14 and F2 to F14
Country Score is in D2 to D14 and G2 to G14
I want the leaderboard to position the countries in order from highest to lowest as the scores are typed in, so that the highest scoring country is positioned in B2 (Flag), C2 (Name), and D2, (Score), and the lowest scoring country is positioned in E14 (Flag), F14 (Name), and G14 (Score).
For a visual representation, please see attached image.
Can anyone tell me the correct macro code to input and how to do this?