What you've described is normal operation of a drop down created using Data
Validation where there are empty cells in the list that provides the contents
of the drop down.

I'm guessing that somewhere you have given the list of names on the first
sheet a name (named range) and it is defined to refer to Sheet1!$B$5:$B$300

What you could do is either somehow provide something to show up in the
as-yet unused cells in that range, but since I don't know what's in them now
(a formula, I suspect) it's difficult to tell you how to do that without
breaking what you have set up.

An alternative is to kind of redefine the range that defines the named
range. You could do this with code like this attached to the
Worksheet_Activate() event of any sheets where you are going to set up the
drop down to refer back to that list. This assumes that the name you've
given the list is MyNamesRange, and that it is on a sheet named Sheet1 -
change the code to reflect your reality:

Private Sub Worksheet_Activate()
ActiveWorkbook.Names("MyNamesList").RefersTo = _
"='Sheet1'!$B$5:" & Worksheets("Sheet1"). _
Range("B" & Rows.Count).End(xlUp).Address
End Sub

Hope this helps, or at least gives you some ideas on an approach to curing
the situation.

"Anita" wrote:

I need help. I have a drop down list which I have been able to set up to
automatically update and everything else that should be. I CANNOT get it set
up to default to the top line in the list.

Cell B4 is the header:(Last Name, First Name)

All of the cells from A5 to A120 are numbered with 1, 2, 3, 4, etc.

Cells B5 to B300 (to automatically update) are blank until a new file is
created listing employees names:

Smith, John
Brown, Jim
Gray, Steve

When I open the drop down in a differnt worksheet in the workbook it opens
to the cell immediately below 'Gray, Steve' ad I have to manually scroll to
the top to select 'Smith, John'.

How do I get it to open on "Smith, John".

I appreciate your help.