Situation: I have been given a new job, at work, where I am now in
charge of the work schedule, scheduling in over fifty employees' work
times. The employees' numbers and names are listed in two columns
that are side-by-side: column A contains the employees' numbers, and
column B contains their names. These columns are in ascending order,
according to when the employees are hired, so the recently-hired ones
are at the bottom of the two columns, and the previously-hired
employees are at the top of the columns; no alphabetical order, here.
Coumn C contains the hire dates of the employees; this column in in
ascending order, with the newly hired employees at the bottom,
previously-hired ones at the top, same as columns A & B. Column D,
labeled "Job Description," lists their jobs ("Full Time Cashier,"
"Part Time Cashier," "Full Time Assistant," "Part Time Assistant,"
etc. All of these columns are on a worksheet named "Employee
Roster."

On different worksheets (ones labeled "Mon.," "Tue.," etc.), I need to
be able to schedule in people for different time slots, for each day:
e.g., on the "Mon." worksheet, I need to be able to select a worker
named "Cindy" to start work at 9:00 am, then another named "Alena," at
10:00, etc. To do this, I select the employee who I am trying to
schedule by going to the "Employee Roster" worksheet and choosing
their employee number, then type it into the cell on "Mon."s
worksheet; e.g., I would go to the "Employee Roster" worksheet, choose
Cindy's employee number, then type that number into the appropriate
cell, on "Mon."s worksheet cell. Nothing difficult, so far.

Problem: The employees usually want the earlier shifts, so they can
get off earlier in the day. So, to be fair, we schedule those
employees who have seniority for the earlier shifts than the newly-
hired ones. However, it's real easy to make a mistake on this. If I
mistakenly schedule an employee who has seniority later in the day
than one who was hired more recently, the one with seniority gets
really mad, and comes complaining to me....stress! How can I get
Excel to look at the list of employees, and prevent me from putting
them in the wrong order?

Problem on the Problem: Here's the real complicating factor (for me,
anyway, as I'm a newbie to Excel). Of course, not all of the
employees have the same job; some are full-time cashiers, some are
part-time cashiers, some are full-time assistants ("box boys/girl"),
and some are part-time assistants ("box boys/girls"). How do I get
Excel to prevent me from mistakenly scheduling not only a newly-hire
ahead of one with seniority, but also to prevent me from scheduling,
say, a part-time Cashier, when I should've scheduled a full-time
cashier? The full-time cashiers would, understandably, be very upset,
if I started to schedule the part-time cashiers in, and not them.

Did all of this make sense? If you have read this far, and would be
willing to tackle it for me, then you are a saint! I have recently
made several mistakes in doing the schedule, and it is giving me a lot
of stress that I am taking home and worrying over to the point of
being sick.