Hello everyone,
I'm working on a spreadsheet for employee scheduling. I currently have two sheets, one for the people at their places, and another for what days and what shift they work.
Is there any way I can make a formula that looks at names of the people at their jobs, and then puts a value into a second sheet where their name is.
So the first sheet has the days of the week horizontally, and the 3 shifts vertically.
The second sheet has the days of the week horizontally, and the names vertically.
I want to be able to type a persons name into the first chart for a day, and have it put 8-1st, 8-2nd, or 8-3rd into the second sheet, under the appropriate person.
Thanks
Dyne
Bookmarks