You can use Data - Filter - Advanced Filer to copy unique values. Note that
you will need to use a named range in order to copy from one sheet to
another. Once copied, simply sort the data.

If you wish this to be automated, I would recommend recording a macro of the
previous actions. You could then either link this to a command button, or a
worksheet_event, depending on your needs.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"golddave" wrote:

I have a spreadsheet where Sheet A contains names (including duplicates) in a
range. I'd like Sheet 2 to list the distinct names in alphabetical order.
Any ideas?

Thanks,
Dave