Hi all,

I need some help with an automatic break rota for work.

Screenshot 2020-09-07 at 19.03.05.png

The aim is to have the cells to the right of the shifts with blanks and 1s in them automatically be filled when the shift is selected. For instance, if I were to change Joe's shift to 10-19, I wish for the cells to automatically fill with the blanks and 1's along with the colour. (1 meaning they are currently working).

I have searched a round and havent been able to find an exact solution to this. It would be probably have to involve a command button when all the names of the staff and their shifts have been entered, you hit the run button and it automatically fills the cells appropriatley on the day's rota for the hours they are working.

FYI, this is an example image, the actual workbook is a lot prettier haha.

I would be grateful if anyone could solve this issue for me!