Auto Update A Validation List

[Guest]

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

 

[Peo Sjoblom]

Use a dynamic range

http://www.contextures.com/xlNames01.html#Dynamic

 

[Debra Dalgleish]

You can do this with programming. There's a sample file here:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'Update Validation List'