Drop-Down List Item Removal

I have a drop-down list that selects from a dynamic range of employees. People come and go; recently an employee quit. I removed the name from the list, but now there is an error where her name was selected at those times. Her name needs to remain in the places where it was selected at the time with no error displaying in the cell—but her name is no longer an option from which to choose henceforth. How would I update the following formula I use for the dynamic range so that, if I take a name away, it won’t display an error in the cell?

=OFFSET(SHEET!$D$1,1,0,COUNTA(SHEET!$D:$D)-1,1)

Any help would be greatly appreciated.

Thank you!

Could you please provide an example sheet? :-)

If the name has been selected, then removing it from the list should not cause an error.

I have created a list list, selected names then deleted them without a problem appearing in the previously selected cells..

So as requested we need a file to understand the issue.

I'm sorry for the late response. I have attached a sample file. Try to delete a Tech from the Data sheet; it will then state that there is an error under the Inoculating Tech tab on the Tissue sheet. How do I correct it? I need to make this correction to other files, too.