I want to create a VBA controlled leaderboard which automatically sorts people into the order of points they recieve, with the leader at the top left (Cells B3 and C3), and the lowest scorer bottom right (Cells D6 and E6)
The configuration is as follows:
Cells B3-7: Person name
Cells C3-7: Score
Cells D3-6: Person name
Cells E3-6: Score
What VBA code do i need to input into excel to make this work?