Hi all,

I am working on a macro and am stuck. I need the macro to be able reference a column from another sheet and then provide a summary of the data in alphabetical order that has the duplicates and the blanks removed.

Thank you!

-norse