I have created an excel work schedule, it contains Columns Mon - Fri and Rows
Employee 1 - 20. Using validation, i have created a list where only the
codes Off, On, Sick, Out, and In can be used.

I want to add a row to the bottom of my sheet that will tell me which
employee is "out". This way, instead of searching through the whole report, I
can look at that row for each day and it will display the name of whoever is
"out".