Is there a way in Excel where you can start typing the name and it will try
and fill it out from a list?

I know in Access, you can create a form that when you enter the first letter
in a field it will try and find from a table the item you want. I also know
in my excel 2007 you can setup a Data Validation to link to a named list so
all you need to do is choose from a drop-down your item. The issue is that
the list I have for the names to choose from is almost 3,000 lines and people
want to either start typing and see a list of choices or have the dropdown
and type a letter to get to the start of that name?

Any suggestions would be helpfull

thanks