data validation in excel 2000

[Sam]

i have a list of fund names say 1000.
i use data validation and want to select a particular fund name like a
combo box does.
but i dont want to scroll down all the way to see fund say for ex. T
but as i type type T i shud go to all the funds named with T . this is
like making it recognise the 1 st alphabet of the fund .

can i do this or do i have to write a macro ?
can anyone plsssssss help.
can u mail me the answer at (e-mail address removed)
thanks a lot !!!!!!!!
sam.

 

[Mike]

Data validation doesn't allow this. If you want this kind
of function, then you will need to use a combo-box. A
macro won't help in this situation.