I have setup a drop down list using Data validation. My challenge is to
select the items in the list by entering the first letter of the word in the
list. For example to choose Bear in the list I would enter "B" and it would
take me to the first entry with a "B".

Thanks in advance.

Richard