Work Schedule - Automaticaly filling name?

Y

YanYan

I have a work schedule starting with Row 4 been Mon-Fri and column A been
name of employee. My cells include a validation list with the different
working codes. Row 7 is where I indicate who is working in Hospital (code
HD). I have so far been entering the name of the employee assigned to HD on
column 7 manualy. What is the formula that will enter the name of the
employee for me. Here is a short sample but my list actualy contains Mon-Fri
for the whole month and about 30 employees.

10/3 10/4
Mon Tue
AM PM AM PM
Hospital
__________________________________________

Employee1 X X X X
Employee2 HD HD
Employee3 OFF OFF HD HD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top