Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Making a rota list
I work on in a Fire Station and we occasionally have to send Fire Fighters to another station. When the person at the top of the list has been sent to another station they go to the bottom of the list, and everyone else in the list moves up a place.
Can I do this quickly in excel? Thanks in advance for any help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making a rota list
Probably. Send me your file and this msg to dguillett1 @gmail.com
On Jan 31, 11:36*am, Tyler Durden <Tyler.Durden. wrote: I work on in a Fire Station and we occasionally have to send Fire Fighters to another station. *When the person at the top of the list has been sent to another station they go to the bottom of the list, and everyone else in the list moves up a place. Can I do this quickly in excel? Thanks in advance for any help. -- Tyler Durden |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making a rota list
On Jan 31, 6:36*pm, Don Guillett wrote:
Probably. Send me your file and this msg to dguillett1 @gmail.com On Jan 31, 11:36*am, Tyler Durden <Tyler.Durden. wrote: I work on in a Fire Station and we occasionally have to send Fire Fighters to another station. *When the person at the top of the list has been sent to another station they go to the bottom of the list, and everyone else in the list moves up a place. Can I do this quickly in excel? Thanks in advance for any help. -- Tyler Durden Sub MoveTopL_MtoBottowSAS() Application.ScreenUpdating = False Range("L3:M3").Cut Range("L13").Insert 'Shift:=xlDown Application.ScreenUpdating = True End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
making a list | Excel Discussion (Misc queries) | |||
making a list ?¿ | Excel Worksheet Functions | |||
Making a list | Setting up and Configuration of Excel | |||
Making a new list | Excel Discussion (Misc queries) | |||
Making a list box of checkboxes | Excel Programming |