autosorting to a leaderboard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create a leaderborad in Excel, wich displays the current position
of a contestent. If his score changes (due to data input) his position at the
leaderborad changes. How do i do that?

I got a list of names and thier value starting at 0 then each round they
will get points. I enter the points after each name and the leaderbord auto.
shows positions, else i need to sort after each input to have the board up to
date
 
Record a macro when you sort your data.

Then do your data entry and rerun this macro. (Tools|macro|macros...)
 
Back
Top