J
JerryBear
I'm trying to create a shift schedule using two worksheets. Worksheet "A" is
where the shift hours, labor rate and day or night scheduled is posted.
Worksheet "B" contains the employee's availability (days/nights available to
work) and has "check boxes" to show who can work when. I'm trying to figure
out how to reference the check boxes from worksheet "B" to automatically
input into worksheet "A" and black out the time slot if they are not
available. For worksheet "B" A1=employee's name,B1=check box AM yes/no(yes
is a check), C1=check box PM yes/no(yes is a check), B2=checkbox for AM shift
(10am-6pm), C2=checkbox PM shift (6pm-11pm). when the appropriate boxes are
checked the times should appear in worksheet "A" or blacked out if left
blank. I'm totally stumped! Any help would be tremendously
appreciated--thanks!
where the shift hours, labor rate and day or night scheduled is posted.
Worksheet "B" contains the employee's availability (days/nights available to
work) and has "check boxes" to show who can work when. I'm trying to figure
out how to reference the check boxes from worksheet "B" to automatically
input into worksheet "A" and black out the time slot if they are not
available. For worksheet "B" A1=employee's name,B1=check box AM yes/no(yes
is a check), C1=check box PM yes/no(yes is a check), B2=checkbox for AM shift
(10am-6pm), C2=checkbox PM shift (6pm-11pm). when the appropriate boxes are
checked the times should appear in worksheet "A" or blacked out if left
blank. I'm totally stumped! Any help would be tremendously
appreciated--thanks!