Hi jaslake

You are a guru.

It's all looking good. I have a few notes.
  1. I opened this spreadsheet on 4 computers and only 1 worked. The other 3 computers don't have the DatePicker installed on the PC's. As soon you open the spreadsheet, the error message shows and goes straight to debug. In the UserForm_Initialize code, frmCalendar.DatePicker = Sheets("Group SR").Range("L1").Value is highlighted. On the other PC, when you update roster it say's "Object variable or With Block variable not set. Intersect(myRow.EntireRow, myCol.EntireColumn) = cel.Offset(0, 3).Value. I did not adjust anything.
  2. I need to modify some of the employees on the roster. Do I change it from the engine or Roster2012 sheets?
  3. In the OTSummary Sheet, when you add a new row the time cannot be adjusted. They default to 00:00.

There is a lot going on. If you can think of something to make it easier, your advice is appreciated.

I'm very happy. Everything else is great. Many Thanks.