Hi,

When I create a drop list by means of data validation, the options displayed are not sorted, since my data source is neither sorted (due circumstances).

Is there any smart way to display the options sorted in the drop list, without changing its source?

Thanks for your help.

ONB