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.