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
thanks a lot !!!!!!!!
sam.