My question is I have a spread sheet built that has a list of names that are populated at different section of the columns. I need a way to alphabetically list them after some one has entered the list and take out the blank spaces that are left when the list is being updated.
The names are being chosen from a drop down menu from a another sheet. So as a group of people show up and are added to the list I wanted the user to be able to just alph the list with out taking names out and adding that person back in a different spot. Sorry if this is not very clear description of the problem. If you have any suggestions I would love the help.