I am trying to build a vacation scheduler for a staff of approx. 100 staff and most of it works fine but I can't figure out one last piece.
What I have is a dashboard, a staff list, a vacation list and then a DOR (day of rest) list.
The dashboard has each employees name in B9:B100
Dates are...