Did you use define a dynamic range named "NameList" ?

To see the definition in the sample workbook, choose InsertName.

BigPig wrote:
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'




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