Carrie_Smattick
New member
- Joined
- Jun 23, 2013
- Messages
- 16
- Reaction score
- 0
- Points
- 0
Hi, all.
I really hope someone can help with this. I have posted in a few forums and I've had no responses, so I'm not sure if what I'm asking for is possible or not.
http://www.excelforum.com/excel-pro...-ranges-then-error.html?p=3288255#post3288255
I am creating a weekend working rota. We have around 30 staff covering weekend working. They work on 4 different contracts, but can only work on any particular contract if they have done so in the last three months (else they require refresher training). If a name is entered for a contract that the worker has not covered in the last three months, I need an error that says that name cannot be entered.
The workers also have the option to be paid for the day they work, or they can take a day in lieu. I need to count up the amount of days taken in lieu each month so we can see how many lost days we have during the week over each month.
I hope I am making sense.
I have attached a sample spreadsheet but I've no idea if I would need a completely different layout to get the results I am asking for. I would really appreciate some help with this as the weekend working has already begun.
View attachment weekend_working.xlsx
Thanks so much.
I really hope someone can help with this. I have posted in a few forums and I've had no responses, so I'm not sure if what I'm asking for is possible or not.
http://www.excelforum.com/excel-pro...-ranges-then-error.html?p=3288255#post3288255
I am creating a weekend working rota. We have around 30 staff covering weekend working. They work on 4 different contracts, but can only work on any particular contract if they have done so in the last three months (else they require refresher training). If a name is entered for a contract that the worker has not covered in the last three months, I need an error that says that name cannot be entered.
The workers also have the option to be paid for the day they work, or they can take a day in lieu. I need to count up the amount of days taken in lieu each month so we can see how many lost days we have during the week over each month.
I hope I am making sense.
I have attached a sample spreadsheet but I've no idea if I would need a completely different layout to get the results I am asking for. I would really appreciate some help with this as the weekend working has already begun.
View attachment weekend_working.xlsx
Thanks so much.
Last edited by a moderator: