Need sorted validation list

K

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
 
Top