I have an employee work schedule already generated. I need to set up the tabs on the bottom for every day of the week. I also have different shift listed from A to G. Example: A is Mon-Fri 6AM to 2:30 PM, B is Mon-Fri 8AM to 4:30PM, C is Tue-Sat 9AM to 5:30PM. I need a spread sheet that I can plug in the employees name and the shift they work in. Then also set up the days on the week on the tabs below. If i were to click on the Mondays tab it will show me whos working on that day. I need to also include a lunch time for each work group. Lunch is to be taken between the 4th hour and the 6th. Last but not least have 1 column to indicate of the employee is on vacation or called in sick. If the box is checked off it would shade in the employee name a different color. not sure if any one has something like this already set up. I have been trying dofferent ways to set this up but can not figure it out. Please help...