I have attached a spreadsheet and I want to make names appear based on the text entered onto a cell from a different tab. When an employee can’t work for a specific reason, I start by typing in any of the codes in yellow from the Codes tab onto the Week Schedule tab for the day that employee can’t work. I’ve typed down what I am looking for in the tabs and hopefully this issue can be resolved. For the employees replacing them on any specific day, I type the duty number of the employee they’re replacing in their row on the Week Schedule tab and day it’ll happen. On the tabs SS-1, SS-2 and SS-3, I want the names of those employees replacing them to appear in the F column next to the specific employees not working on that day. In the SS-1 tab on March 29th, I typed in Jack, Mary and Lea under the F column. On March 30th in the same tab, I typed in the same names. On the SS-2 tab under March 29th, I typed in matt, lee and jack. On the SS-3 tab under March 29th, I typed in James, Johnny and Daryl. Thanks for the help!
Bookmarks