G
GMRJEN
How do I generate a drop down list that has no blanks in it? I used data
validation to pull the list names from another column. However, the column
has blanks in it. It would be great if there were a way I could delete the
blanks in the drop down list and sort it by alpha.
validation to pull the list names from another column. However, the column
has blanks in it. It would be great if there were a way I could delete the
blanks in the drop down list and sort it by alpha.