Scheduling Inquiry

Hello all,

So I am new to the forum, so I apologize in advance if this isn't the correct thread to post under. Anyways here's the situation.

I've been re-building a schedule for my work (of approximately 45 people). Before, we were to basically go off the prior week's schedule in order to fill the approximately 35 functions for each day. My first idea was to go through and list every individual's capability on sheet 2 and perform a data validation so we were able to have a drop down list to choose a function from. We knew which function to assign a person from a checklist we normally print off and check-mark each for each day of the week.

Having the drop down list cut about 60% of the time, which is fantastic. However, I am wondering if it is possible for me to create an automated checklist with the list of functions for each day (Monday - Saturday).

To give you an example: On Monday's I need one person to do "Secured Card." Now I have gone through and made sure the employees that know how to perform this had this function under their drop down list. What I am hoping this automated checklist could do is basically put an x or a check-mark for the function Secured Card under Monday as I selected it under the employee.

I hope I am being clear in my question. If anyone has any suggestions or questions for clarification, I'd appreciate the feedback.

If I need to post any screenshots or attach anything, again let me know.

Thanks in advance! =\

Hi have a look at this it may help you

http://www.excelforum.com/excel-gene...ling-help.html

Toonies

Happy Easter,

I have attached a word document with a couple quick screen shots of what I am currently going off of, and a little explanation of what I am hoping could happen.

Again I appreciate the feedback and direction.

Thanks!

Toonies,

I took a few looks at that old thread and realized this is basically what I need except on another sheet.

I would attach the excel file since I don't exactly know how to plug in the formula in the schedule. That and I wouldn't feel comfortable with broad access to the file with my employee's names on it. Would you feel comfortable if I maybe sent you a personal e-mail on the issue?

Or anyone for that matter?

Any help is greatly appreciated!