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?
Bookmarks