Is it possible to do something like this (="*"&EmpListThur&"*") in a data validation. Currently it's not working.
EmpListThur is a list of all employees who can work Thursday.
EmpListThur has null values or blank cells so I can type anything into the schedule whether it is on the list or not. This is to my advantage because on some days a driver comes in early (ex: Smith in @6am ) and I can just put it right on the schedule with his name. However, this means that the person doing the schedule could type the employees name wrong(ex:Smit in @6am) and then the calculated hours for that employee would be off.
EmpListThur is a list of all employees who can work Thursday.
EmpListThur has null values or blank cells so I can type anything into the schedule whether it is on the list or not. This is to my advantage because on some days a driver comes in early (ex: Smith in @6am ) and I can just put it right on the schedule with his name. However, this means that the person doing the schedule could type the employees name wrong(ex:Smit in @6am) and then the calculated hours for that employee would be off.