On Jul 11, 4:10 pm, Randy Harmelink wrote:
I think what I would do is expand the employee roster worksheet to
have all the fields you need to do the scheduling, then generate the
daily schedules from that database. That way, you're doing all of
your scheduling in one place, so it should be easier to do the
scheduling process.

For example, if your "database" contained fields like:

-- Employee Number
-- Employee Name
-- Hiring Date
-- Job title
-- Part/Full time
-- Monday Start/End Time (or whatever is needed)...
-- Tuesday Start/End Time...
....etc

Then you just need the "Monday" worksheet to extract and format the
necessary data out of that "database". You could sort that database
easily, as needed -- for example, to keep them in seniority order.
And you could use the "Filter" process txlya else mentioned to
restrict the database to "Cashiers" or "Assistants" when you're doing
each, just to make the process a little easier scheduling each job
category for the week. You may even be able to get by with JUST the
database, depending on how you have to post the schedule -- it may be
able to be formatted for printing as-is? Plus, you wouldn't need to
be retyping employee numbers between sheets, or constantly hopping
between worksheets when creating the schedule.

Of course, the devil is always in the details...but I think you're
generally better off with the data storage and maintenance being done
in one place in a consistent format. It usually gives you more
flexibility for manipulating the data later on.

On Jul 11, 1:02 pm, Ray wrote:





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.- Hide quoted text -

- Show quoted text -

So, you're saying to just put everything on the same worksheet. That
certainly would make things easier, as I wouldn't have to be
constantly refering back to the employee roster, when I schedule each
day. Thank you for that idea.