Trying to select a row name by column date if a value is present

[DOMASHNIA]

So, as the title says....



Im making a staffing sheet for work. I would like EXCEL to generate a daily staffing sheet based on the people working on a given day.

the schedule is 6 weeks and the columns auto populate the dates when the new 6 week starts. The employee names are static. The employees work Am or PM shifts which are designated by A, P.

Im terrible with excel and ive finally gotten to a point where youtube can no longer help me (or i simply dont know what to search for)


So, if I input a date, I want just the people (on that date) with an "A" to populate to a group

and the same for those with a P.

ideas?



There would be 9 sheets (each for different units of this hospital) and then...given the day entered on the final "HOUSEWIDE" sheet....it would automatically fill in the spots.

i uploaded the excel file with the test names and "schedule" and how it should look on the housewide sheet