I am trying to figure out how to validate the entry into a cell based on a list located in the worksheet. For example. I have a list of names, and the user should enter one of those names in Cell A3. The only problem is that the list of names changes. So I can't write the validation to reference the specific names. I hope I can have the validation reference the range that contains the names and makes sure that the entry is one of those names.

Does anyone knwo if this is possible, and hopefully how to do it? Thanks for any help you can provide.