When the dropdown list opens, it matches the cell value to an item in
the list, if one exists.

Instead of leaving blanks so the list can grow, you can use a dynamic
name for the range instead. There are instructions on my web site:

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


Pitbull wrote:
Hello all,

I have a question about Data Validation.
I set up a range which can be modified at any given time.
I gave this range a name (Hello1)
Now, on another cell I use Data Validation, List, =Hello1
It works fine, except that if I have empty rows at the end
of my range, it starts with the bottom (which shows
nothing) instead of having the drop down showing the first
few rows of my range.
In other words, I would like to have the Drop Down menu
show the first choices instead of the last choices of my
range...

Example: In E1:E20 I have a list of items, Now I Insert
Name Define E1:E30 with the name "Hello1". I would like
to have it show E1:E8 instead of E23:E30. Is there a way
to do it?

Thanks in advance for any help!
Pitbull



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html