I have to make a roster with 3 shift timings for about 10 employees. I need a macro created so that it automatically changes the shift timings of the employees along with week off's. I should also be allowed to make amendments to the sheet manually as the rostered timings/week off's of the employees may require to be changed. What I have written here is just a gist. I can explain better over the phone.