Hi folks -
I'm working on automating a schedule template for work. On one page, I have the employee names, roles, and dates as headers. If an employee works, they have either an 'X' for for a full day or an 'H' for a half day.
On the second tab, I want to be able to select a date, then have the names of everyone that works listed automatically. I've attached a (very simplified) sample here. So basically, when a date is selected in B1 of the schedules tab, anyone that works on the date selected is listed in column 'A'.
I've been trying to figure out how to make this work, and am wondering if it's possible. I think it must be a series of nested IF statements, maybe with an index match? Otherwise perhaps an array?
I'm working on Microsoft Office 365.
Thanks in advance!
Bookmarks