Scheduling

Hey Guys, (Gals?)

I have made a schedule for work. However, I would like to take it to the next level, here's where it gets completely confusing and out of my boundary!

I have attached the schedule for reference.

Now, on the first sheet that says schedule. I would like to take the shifts ( 7 -12, 10 - 3, 5 - 10, etc...) auto populate the other sheets (Compound, Greeter, Cashier, etc..) in the same format that's there now.

For example. If you look under the "compound" sheet. You can see the yellow bars denoting the length of the shift. The grayed out sections are breaks. The yellow sections are open shifts, the blue ones are mid shifts and orange are closing shifts.

My question is how do I make it so when I enter a scheduled value on the "schedule" sheet it will auto populate the other sheets in the same format with the colors, etc?

Any help would be greatly appreciated

Thanks,
Brad, J.