Sorting and Assigning

I am trying to organize a families car availability and which car is available to do a certain task(i.e errands, etc).

So I have 6 possible drivers for 2 cars and 4 possible tasks. I am trying to code in VBA who can drive what car to do what task. Some drivers can drive one car, while others drive the other, but some can drive both. I am first trying to sort these because some tasks are just easier with one car as opposed to the other. Any suggestions how can I group them based on which or both car one can drive? And then how I can forward a certain task to that specific type of car?

I would just tell everyone to go buy their own cars....

Try adjusting your axis names:

Errands down left, cars on top driver in the middle instead of Y/N???

I was trying to code it in VBA as the chart is updated. Sorry, not everyone can afford their own car. Basically, I am trying to sort who can drive car 1, car2, and both cars. Then assign them tasks all within VBA.