Hello all. I have a vacation tracker that we use to track what vacation days each employee has scheduled for each day of the month. I need to be able to, in another sheet that is formatted like a calendar, list all employees who are off on each day. My data sheet looks like the following:
sheet1.example.png
The next screen shot is of the calendar and what the results would look like after the script is run.
sheet2.example.png
I did an IF statement that worked... except that there would need to be an IF statement for every employee on each day of the month which didn't seem to be the most efficient. I'm open to any formulas or VBA that would accomplish this.
I would greatly appreciate any guidance.
Bookmarks