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

Attached Images

Untitled.png (27.2 KB, 17 views)

Attached Files

Donald Project.xlsx (78.1 KB, 9 views)