DESPERATELY NEED HELP
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 |
DESPERATELY NEED 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 |
DESPERATELY NEED 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 |
DESPERATELY NEED 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 |
All times are GMT +1. The time now is 03:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com