Data Validation Drop List Fill In?

[lex007]

I have been trying to find out if there is a way that when a data validation drop down list is filled in by just typing the first characters instead of "scrolling" ?

Also, can the list be from a different tab and not in the same sheet?

I am dying to know

Thank you!

 

[texasalynn]

take a look at this