View Single Post
  #1   Report Post  
Pitbull
 
Posts: n/a
Default First Letters Grab

Hey All!

I am trying to do something in Excel that is available in
Access.

For example, I have a database on sheet1 with a bunch of
names and other columns.
Ex:
Bill
Bob
Billy
Boris
Brent
Brad

Now, on sheet 2, I would like to have some kind of tool
that would tell me what is available when I type the
begining of the name.

For example, If I type
"Br" I would like to have it say: choices are Brent and
Brad. (actually, in a Drop Down would be awesome!)
When I type "B", I would have all the Bs in the Drop Down.

Just like access does. It this something that is possible
in Excel?


Thanks in advance for the answers!

Pitbull :)