HI guys,
I"m new here and I"m trying to figure out if there's a way to input a formula in a calendar and have it automatically update it in my employee schedule.
What I want is for my employees to have access to request days off on a certain day and have that reflected on a work schedule for the week.
For example if on October 31, 2 of my 10 employees want to put their names on there to request vac, then it would show up as their name marked with VAC on their work schedule.
I would have a calendar and a work schedule on the same file. I"m trying to do this to save time in creating schedules. Once the employee inputs a request, it will show it on the work schedule marking her off for VAC.
I think to start I would have to do an if 4 cells contains any of my employees names with VAC, then go to the schedule and mark them as VAC. I wonder how I can do this.
Any suggestions would help!
Thanks!
I"m new here and I"m trying to figure out if there's a way to input a formula in a calendar and have it automatically update it in my employee schedule.
What I want is for my employees to have access to request days off on a certain day and have that reflected on a work schedule for the week.
For example if on October 31, 2 of my 10 employees want to put their names on there to request vac, then it would show up as their name marked with VAC on their work schedule.
I would have a calendar and a work schedule on the same file. I"m trying to do this to save time in creating schedules. Once the employee inputs a request, it will show it on the work schedule marking her off for VAC.
I think to start I would have to do an if 4 cells contains any of my employees names with VAC, then go to the schedule and mark them as VAC. I wonder how I can do this.
Any suggestions would help!
Thanks!
