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.

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

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