Hi everyone.

I am trying to create a data validation drop-down list. I need to reference a named range, however, I also want to be able to add values that are not included in the named range to the list. I realize that is inefficient, however, this is a client deliverable and my boss will not allow the additional values to be a part of the named range. Any suggestions?