Sort combobox items alphabetically

[aprilapple04]

I have created a dependent combo box with dynamic list which updates its list automatically according to the user's selection....(as attached)
however I wanted to have the items arranged in an alphabetical order. I don't want to sort the original entries. May I know how can I do that?


Thanks a lot...

[Ursul]

It was only the simple matter of using Sort & Filtering so that the inputted data was in alphabetic order

Sort.xlsm

Cheers

[aprilapple04]

Thanks Ursul...

But I don't want to sort the inputted data (the original data set)...is there any other ways?

[Ursul]

Don't thin so - sorry, unless you use VBA which I'm not into.

Cheers,

[jindon]

Try the attached

[aprilapple04]

Thanks a lot

[Ursul]

Well done jindon - you're a much better person than I