List Box Contents

[ChrisMattock]

I have a list box on Sheet one of my project, dropping down it lists
names taken from sheet 2, I have it set up for 20 cells, but so far
there are only 5 names to pick....

A B C
1 Name 1 Telephone No. Address
2 Name 2
3 Name 3
4 Name 4
5 Name 5
6
7
8
etc

The list box shows all the blank spaces, any way of making the drop
down box not show the blanks? Also Ideally you would be able to add
names and it display them alphabetically, reorganising the names on the
sheet is probably no possible as the relation cells have info such as
phone numbers in... as above....

 

[davesexcel]

You could use a dynamic range

http://www.contextures.com/xlNames01.html#Dynamic

You should have no problem sorting your list, just highlite the range
you want to sort and goto
data,sort, then pick column A as the first column

 

[ChrisMattock]

That's awesome, thanks!