Hi Community,
I'm producing a template for auditing purposes and is going to be provided to outsourced companies to complete the task.
I'd like to know if there is a data validation or macro that wont allow the auditor to leave a cell blank when he clicks on it because in the past we have had a very bad experences with a lot of blank or n/a information. Thus i have made data validation lists and unchecked "ignore blank", but i want to get that extra step.
Range is from Coloums A-L.
Thanks in advance.
Regards,
Nathan
I'm producing a template for auditing purposes and is going to be provided to outsourced companies to complete the task.
I'd like to know if there is a data validation or macro that wont allow the auditor to leave a cell blank when he clicks on it because in the past we have had a very bad experences with a lot of blank or n/a information. Thus i have made data validation lists and unchecked "ignore blank", but i want to get that extra step.
Range is from Coloums A-L.
Thanks in advance.
Regards,
Nathan
