Sort a validation list?

[kk_oop]

Hi. I have a range of cells that are NOT sorted and should not be
sorted on the worksheet. I want to use that range as a Data Validation
List, but I want the values to be sorted on the validation list.

Any suggestions?

Thanks!

Ken

 

[Don Guillett]

a duplicate list?

 

[kk_oop]

a duplicate list?

I'm not sure what is meant by "duplicate list." I'd like the
validation list to change if I add new items to the worksheet range.
Is there a way to take a named range on one work sheet and display it
sorted on another worksheet? If there is, I can use that second list
for my Validation List. Is that what you mean? Can this be done?

Thanks again!

Ken

 

[Don Guillett]

Yes, use a defined name to name your list so it will be self adjusting.
goto the sheet you want the list on>Insert>name>define>name it mylist>in the
refers to box type in =offset($a$1,0,0,counta($A:$A),1)>click OK. Now you
have a list =mylist. Add to and sort as desired.
You could even create a macro to update from the other list so you don't
have to update.