Refer to three cells to populate For next

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: hotherps (hotherps.149h93_at_excelforum-nospam.com)
Date: 04/05/04 

Date: Mon, 5 Apr 2004 17:37:53 -0500

I'm not sure how to go about this. I want populate a work schedule with
tasks based on availablity, need, and trained criteria.

Let's say someone is needed to work in task ABC from the hours of 8am
to 10 pm. This person must also be trained in ABC to qualify and must
be working a shift in that range to be scheduled.

So if Employee 1 works 9am to 5pm and is trained in ABC, a range of
cells in Employees1's row should read "ABC" "ABC" etc. in 20 min time
intervals, until his shift ends or the need for the shift ends.

So I guess the code will have multiple conditions to satisfy before
populating the cells with the appropriate task. There are multiple
tasks and multiple employees. If the need for the task becomes 0 or the
employee's shift has ended, the code should loop to the next cell, and
so on.

I'd like to set this up properly but am unsure how to do it.
Thanks!:confused: 

---
Message posted from http://www.ExcelForum.com/

Relevant Pages

  • Re: Make a work schedules for my employees
    ... keep a running total of hours scheduled per day shift, dinner shift, night ... > You find a template for employee work schedule here ... > Control the things you can and Don't Worry about the things you can't ... >> What program should I use to create a work schedule for my employees. ...
    (microsoft.public.office.misc)
  • Re: I got a job (third shift content)
    ... hardest part of working that shift will be on the weekends. ... it all the time and it's tough on their days off because their bodies ... are so used to their work schedule. ...
    (rec.music.phish)
  • Re: Number of working days
    ... describing, it would take quite a bit more logic like what employee, what shift, work schedule, etc. So, nothing will work for everything, but the routine I provided could be modified to take those circumstances into consideration. ... A swing shift works 7 day and off 2. ... When they come back to work the swing to the 2nd shift then to the 3rd. ... If you are off work on a holiday, it is just another day off. ...
    (microsoft.public.access.forms)
  • Re: Getting a scrolled widgets scrollbar from within an object
    ... my $self = shift; ... Is it possible to run that from populate? ... the "dirty trick" works with a delay value of 1. ...
    (comp.lang.perl.tk)
  • Can this be done? Excel output page problem.
    ... We use excel for our work schedule. ... Dayshift ... There are varying amounts ... of people on each shift. ...
    (microsoft.public.excel.programming)