That is excellent. Thank you

Is there a way to protect the cells which have text in them (column "To Be Completed By:" ). I do not want anyone to delete the text from within these cells as at the moment the text can be deleted.Can the cells have a password or something which stops the text from being deleted without affecting the dropdown list you set up with code


Thanks again