I have an excel sheet that is used to make up a monthly working schedule for 15 employees
what I want to do is have the sheet pick the name from the list and fill it in
each employee has a number associated to there name 1 = Tom, 2= Bob, 3= beth ect...
when I enter 1 into a cell Tom's name pops in 2 and its Bob ect How do I set this up?
what I want to do is have the sheet pick the name from the list and fill it in
each employee has a number associated to there name 1 = Tom, 2= Bob, 3= beth ect...
when I enter 1 into a cell Tom's name pops in 2 and its Bob ect How do I set this up?