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

--
spankydat
-----------------------------------------------------------------------
spankydata's Profile: http://www.excelforum.com/member.php...fo&userid=3721
View this thread: http://www.excelforum.com/showthread.php?threadid=56931

Why don't you just sort them?

--
HTH

Bob Phillips

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

"spankydata" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>
> Hi
> I have a workbook containing colleagues' daily hours worked on separate
> sheets. I have then created a worksheet totalling how many hours per
> week each person has worked. How do I list the names in order of who
> has worked the most hours? I have the names in a row and the hours in
> the columns. I think I need some kind of auto sort that will display
> the names.
> thanks
> Steve
>
>
> --
> spankydata
> ------------------------------------------------------------------------
> spankydata's Profile:
http://www.excelforum.com/member.php...o&userid=37217
> View this thread: http://www.excelforum.com/showthread...hreadid=569313
>

On Tue, 08 Aug 2006 08:59:16 +0100, Bob Phillips <(E-Mail Removed)>
wrote:

> 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.

--
Steve (3)

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


--
spankydata
------------------------------------------------------------------------
spankydata's Profile: http://www.excelforum.com/member.php...o&userid=37217
View this thread: http://www.excelforum.com/showthread...hreadid=569313