Hi, I have two lists. One is of the employees home position, and another is of other positions they are cross trained in. Lastly, I keep record of if they are absent or not.

How in excel can I program, the list of all the home positions and slot the employees into all the positions, and ensure they are all covered when there are some people absent? How would I structure this in excel?