Making a shift list dependant on staff password.
I would like to have a randomized password on the staff list for each staff. And on the Shift list tab can we have it so depending on what password is put in, it would populate all the shifts that were in between the start and end dates of that are inputted above. if they are not working a day then that day would state "Off". Is this possible? This way the staff can print out their schedule or just view it
29133839a.xlsm
29133839a.xlsm
Martin Liss
What do you mean by "randomized password"? By "for each staff" are you implying that there would be the 3 columns on the Staff List for every staff member? Should Employee1 be able to see Employee2's data on that sheet?
ASKER
So i meant that the staff password would be on the staff tab. I would tell everyone their passwords and when they open the excel sheet they could put their password in and the time frame that they want to see their shifts and then it would populate a schedule of shifts for that person. The password is so that they cant see what other people are scheduled for.
Another way to do it if they all use different PCs or the same PC with different logins, would be to use their user name (which is stored in the PC). If you want to stick with the password approach I can generate random, secure, passwords like mDUMhDXG (can be any length you desire and/or can include symbols) or random words like 'sneaky llama arcana'. Let me know.
Try this. Go to the Shift List sheet and click the button. This is a "proof of concept" version and doesn't yet show any data. Employee1 is set up with password xxx.
29133875.xlsm
29133875.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Wow you did that quick and I love the log in button that you added! Thats amazing!
ASKER
Is it possible to show the days that they do not work as well? And it would say "Off" in the other two columns for that date?