go to a specific letter in a list

P

Petya

Dear All,
i have a list created, with a lot of customers (its a dropdown list, where
you can roll to the desired customer). Is it possible to do the following: if
i start to write in the customer name; (let's say Hilton), than at Hi it
gives me the Hilton name already (of course if there is no more with Hi start.
I hope it is clear:)

thx a lot
Peter
 
P

Petya

If this is an already defined data validation list, your idea does not work
unfortunately..
 
M

Mike Rogers

Petya

In xl2k you can sort your list "ascending" and at each change in the first
letter of your list, insert a cell and place the appropriate letter. In your
dropdown just enter the first letter and the click the dropdown arrow and you
are at the beginning of that part of your list.

Does that help?

Mike Rogers
 
R

Roger Govier

Hi

Debra's technique at the location already given to you does work.
However, if you are having difficulties with using the Combo box, there
is another, (not as good) method just using the Data Validation itself.
It will allow you to type a letter and jump to the first entry with that
letter rather than having to scroll through the whole list.

http://www.contextures.com/DataValHeadings.zip
 
Top