Based on my example table, i need a way to extract the data from the roster, so that i would be able to automatically populate the yellow areas of the 'AMPM' sheet with the names of the people working the respective shift.
An example of a desired outcome is also included
Thanks for the help in advance!
Bookmarks