I have an excel scheduling macro that reads a list of reviewers choices and and assigns meetings according to when the applicant signed up. The logic is as follows:
Looks at applicant #1 1st choice.
Assign meeting to 1st choice if available.
look at applicant #2 first choice.
Assign meeting if available
repeat until end of list
start again with applicant #1 2nd choice
I need to update it so if applicant #1's first choice is not available, it looks at the second choice and assigns a meeting before advancing to applicant #2.
It should not produce duplicate meetings.
This project needs to be done by thursday morning.