I have a roster that is in order by room numbers and the names are constantly changing on who is in the rooms. The problem is I have two other worksheets the information needs to be on. One needs to be in alphabetical order, the other in order by date of arrival/imput. Is there anyway to set it up to do all three with just one input. Thanks for your help.

Naomi