Hello, so every month at work, we create a new schedule for the executive staff. The schedules are created in excel, they look something like this:

1 2 3 4 5 6 7
Scott E OFF E L M E OFF

Where E is an early shift, L is a late shift, M is a mid shift and obviously OFF is off.

What I would like is to create a button that will schedule various people for their standard shifts. For example, I open every Monday, and I would like the button to use that information to go ahead and generate those shifts. Then, I want the program to go back and generate who is in charge for each day.

I know this will be some VB code, can someone point me in the right direction as to what I need to start researching?

Thanks,
Scott