View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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