autosorting to a leaderboard
 

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

autosorting to a leaderboard
 

Record a macro when you sort your data.

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

ano wrote:

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

--

Dave Peterson