You could put the data they were given the assignment and then sort
descending so the newest assignee is at the bottom?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html


"newuser" wrote in message
...
How do I make a list of employees that will rotate. Ex. I want to put
there
name address assignment and telpehon number. After a person gets the
assignment he moves to the bottom of the list and the next person moves up
in
the que waiting for an assignment.

HELP