Richard
I have another sheet that uses the ID in a lookup formular. I am looking for a way to validate the date, so the user can either type in a number in column A or the name in column B and the two columns stay synchronised

thanks

Vetequk