AutoComplete from Validation List

  • Thread starter Thread starter Poo Poo Jones
  • Start date Start date
P

Poo Poo Jones

I need to add a column to a worksheet that shows the Country of Orgi
for a product and that county's assigned computer code (Ex. Unite
States - 10001). I have a list of counties and correspoding codes bu
the list to so long (300 countries) that I would like to be able t
type in "United" and have the cell auto complete the rest. Otherwise
have to scroll through a drop down menu of over 300 entries.

Any suggestions would be appreciated. Thanks
 
Debra Dalgleish shows a way to use two data|validation cells.

The first cell can show A through Z, then second cell can show the countries
that start with that first letter.

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

As an alternative, you may want to look at using a combobox from the control
toolbox toolbar (not from the Forms toolbar).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Variable Validation List 2
Double Drop-Down Validation in Excel 2007 1
data validation list from two columns 1
Data Validation 4
Autocomplete for Drop-Down? 1
data validation lists and invoices 2
Data Validation (Criteria = list) 3
Excel sheet validation 1

Back
Top