I have started a book club and made an excel sheet for all of the details
including the books owner. If a member has put on multiple books, their name
appears multiple times. What i am trying to do is generate a list with
everyones name on it only once, from the long list of repeated names. This
short list will then be linked to the drop down box, so that a new member to
the book club only has to enter their name once, then it appears in the drop
down list.