Hi Debra,

I tried using what you had as an example, however it did not work. I named
the database, extract, etc, even copied the event code and pasted into my
worksheet, then changed the sheet names. When I type in a letter or more, and
then select the drop down, I get the whole list of names. If you could offer
any pointers, I would be grateful.

"Debra Dalgleish" wrote:

You could us an advanced filter to create a short list of names and base
the data validation dropdown list on that. Index and match formulas can
return the matching data.

There's an example he

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

Under Data Validation, look for 'Limit Selection List'