Spreadsheet is attached.
I have a list of 3 people (Tom, **** and Harry).
I have 3 possible sites for each of them to be on any particular day (Site1, Site2 and Site3).
So, I have a worksheet set up with a row for each day of the year; then 3 columns for Tom, **** and Harry. For each day, I put in which site they are working at. What I want to do is have 3 subsequent worksheets for each site.
In the Site1 worksheet, I would have 3 columns (Person 1, Person 2, Person 3) and a row for each day of the year. What I'd like to do is have a formula to look in the main worksheet (titled "Calendar" in the attached spreadsheet) and for each day, look to see who is listed for each site and place them in the Person 1, Person 2, and Person 3 columns, if applicable. In the attached spreadsheet, I manually put the names into the Site1, Site2 and Site3 worksheets, but I'm hoping there is a way to get this with a formula.
Bookmarks