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

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

nu,

I think Nick Hodge's approach might be the simplest quickest solution.
However, if you need a scrollable range on a worksheet, I created a small
workbook, using vba code to do that.
You click a button and select a scroll range and then use the provided spin
button to move the items in the range up or down.

To any that want a free copy of the workbook, email me with your request
and be sure to include your real name and geographic location.
(i like knowing where in the world my stuff is in use)
Remove XXX from my email address... XX
--
Jim Cone
San Francisco, USA (my location)
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"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

a field with date of assignment
with closing sheet or macro sort it.
Robnific FIP XL
Amsterdam
www.allocator.nl
<everything you always wanted to know about XL but where afraid to
ask