Hi Suzanne,

did you try autofilter?

regards from Brazil
Marcelo

"sedonovan" escreveu:

Hi all,

this worked for me yesterday, but I don't know why it won't work now.

Say I'm searchig in a VERY long list (by the way the list is created from a
lookup table) and I want to find names beginning with M - is there a way to
type M into the cell rather than scrolling through the whole list?

Many thanks again
Suzanne
:)