View Single Post
  #2   Report Post  
Old August 1st 10, 07:23 AM
wickedchew wickedchew is offline
Senior Member
 
First recorded activity by ExcelBanter: Aug 2010
Location: Philippines
Posts: 161
Default

There are 2 worksheets in this attachment.

The first sheet, you have to select a name from column C. The drop-down is dependent on the number of people per shift.

YELLOW = OPENING STAFFS
ORANGE = OPENING AND MID STAFFS
GREEN = CLOSING STAFFS

The second sheet does it automatically. You just need to select an employee E6 and the rest will populate.
Attached Files
File Type: zip DTL.zip (8.0 KB, 74 views)