I have got two sheets, "Shifts" and "Holiday Entry"
I am looking for 3 restrictions in the "Holiday Entry" sheet:
On Holiday Entry Sheet:
Column A when I type "Badge" number and using vlookup it fills B:G except D (where I type the date).
Restriction 1:
If I type a same date for the same staff, I want a error messege "YOU HAVE ALREADY BOOKED THIS DATE".
Restriction 2:
If I type a date and staff is not contracted on that day, I want a error messege "YOU ARE NOT CONTRACTED ON THIS DAY". Please see the shift pattern in the sheet "Shifts"
Restriction 3:
All the dates I will type will be restricted between a range (i.e. 01/01/2020 to 31/12/2020). Any date I type outside this range would give me a error messege "DATE IS OUTSIDE THE HOLIDAY YEAR"
Sorry I coudn't upload my worksheet!!
I am looking for 3 restrictions in the "Holiday Entry" sheet:
On Holiday Entry Sheet:
Column A when I type "Badge" number and using vlookup it fills B:G except D (where I type the date).
Restriction 1:
If I type a same date for the same staff, I want a error messege "YOU HAVE ALREADY BOOKED THIS DATE".
Restriction 2:
If I type a date and staff is not contracted on that day, I want a error messege "YOU ARE NOT CONTRACTED ON THIS DAY". Please see the shift pattern in the sheet "Shifts"
Restriction 3:
All the dates I will type will be restricted between a range (i.e. 01/01/2020 to 31/12/2020). Any date I type outside this range would give me a error messege "DATE IS OUTSIDE THE HOLIDAY YEAR"
Sorry I coudn't upload my worksheet!!