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 :)
|