Use a dynamic range
http://www.contextures.com/xlNames01.html#Dynamic
--
Regards,
Peo Sjoblom
"Dmorri254" wrote in message
...
Hello,
Does anyone know how to dynamically update a validation
list...example..lets
say I have a list of names and I want to add a new name...can I do this
via
the validation list instead of adding it to the actual list on my lookup
sheet??
thanx