View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Rogers Mike Rogers is offline
external usenet poster
 
Posts: 194
Default go to a specific letter in a list

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


"Petya" wrote:

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