I've got an abbreviated sample file attached. I have an Excel file containing multiple worksheets, each with a column of text information (names of people). The number of names in each worksheet varies. I want to copy those names from each worksheet into a single, new worksheet. Ultimately, I want to alphabetize that single column as well as eliminate the duplicate names, such that I end up with a list of all the unique names from the multiple worksheets. Seems relatively complex to me, but hopefully not so much to more experienced users. Thank you.
Bookmarks