Code problem and I'm stuck on if this chart is the best solution for my requirements

I want to be able to make a chart/ schedule that has my information of names and requirements. I want to make the least number of trips to Ohio in order to cut costs. I also need to add a few more names any suggestions??

Sometimes when I delete a name from the bottom chart the red block doesn't show up in the chart above.

We have two shifts AM and PM

Here are the requirements
- 9 drivers in ohio every day
- 3 drivers in WV every day
- A driver cannot work more than 5 consecutive days
- A driver must have 2 days off (preferably after the 5 consecutive days)
- We need to take a truck to ohio to transport drivers back and forth
o We want to make the least number of trips to cut costs

AM Drivers
Abbott
Chambers
Christian
Cost
Dave A
Dennis
Echard
Howell
Morton
Murphy
Paxton
Perine
Pratt
Prettyman
Robinson
Seymore
Sparks
Wills

PM Drivers
Ballenger
Barnier
Bork
Brown
Dickens
Ellis
Epling
Exline
Gragg
Harper
Henderson
Hoak
Kesling
Meahl
Rosenburg
Savage
Sine
Strawderman
Taylor