LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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 :)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding Numbers with Cells that also contain letters Adam Excel Discussion (Misc queries) 7 December 29th 04 02:41 PM
how to sum up letters instead of numbers? Iviio Excel Discussion (Misc queries) 4 December 27th 04 12:22 AM
how to assign a value to the alphabet in order to add up letters Robert Horne Excel Discussion (Misc queries) 1 December 10th 04 08:15 PM
row numbers & column letters ALOlson21 Excel Discussion (Misc queries) 3 December 10th 04 05:45 PM
How do I change column labels from numbers to letters in Excel? AllisonCincy Excel Discussion (Misc queries) 2 December 9th 04 12:55 AM


All times are GMT +1. The time now is 08:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"