Most hours worked

[spankydata]

Hi
I have a workbook containing colleagues' daily hours worked on separat
sheets. I have then created a worksheet totalling how many hours pe
week each person has worked. How do I list the names in order of wh
has worked the most hours? I have the names in a row and the hours i
the columns. I think I need some kind of auto sort that will displa
the names.
thanks
Stev

 

[Bob Phillips]

Why don't you just sort them?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[SteveW]

Why don't you just sort them?

Yes, and obvously if this is a repetitive task.
Record the sort as a macro and assign a button or command to it.

 

[spankydata]

thanks
I just wondered if excel could auto update the sort when new figures
are input
Steve