drop down boxes query?

[birchy]

hi,

i am attempting to create a drop down box that you can (a)
search in by entering letters ie. type a and it goes to
the a's and (b)can enter you own data in ie. the option
you require isnt there so you can go to a blank one and
enter your own data.

i have seen it on operation before but am lost as to how
to do it.

please can anyone offer any help at all?

many many thanks.

Cheers.

 

[Marcel]

Have you tryed Data - Filter - auto filter

 

[birchy]

aha llok promising yeah!! ok so i have a huge lsit of data
but i want the drop dpwn box in a differnt coloum. any
ideaS>?

thanks so much for your help!!