Hi,
Im working on a sim project that includes scheduling for a 24/7 company. In order to track the persons that are suppose to come to work on each shift i decided to make a calendar type of sheet so i can see forecast for the month
I made 3 sheets one for morning, afternoon and night shifts and added manually the persons that needed to come each day.
Now, i was wondering if its possible maybe to have a single drop down menu with "Shift" on it and have it display the persons per shift once i select from the list?
Is this kind of filter even possible on excel?
Thanks in advance
Bookmarks