I don't know if I'm asking for the impossible. I know that Excel will "guess"
what you are typing based on previously entered values in a field but is
there a way I can program a column to take those guesses from values in a
column on another sheet in the active workbook?

My user needs to type street names into a field. These street names must be
typed to exactly match street names in a street name column on another sheet
in the same workbook. I would like it to be so that when she starts typing
the first few letters of a street name, Excel will 'lookup' what she's
typing from the list of street names on the other sheet and offer matching
values for her to choose. Once she clicks to choose them, like the built in
feature, Excel will complete the entry for her.

I hope this makes sense. I don't know how else to describe what I'm looking
for. Thanks in advance for any ideas or advice.
--
BJM
ACE Assistant
Gary Allan High School

Hi,

Since you want exact matches you might look at Data, Validation, List using
as the list the names in the other field. However, DV, does not provide
auto complete so you might look at

http://www.contextures.com/xlDataVal10.html
http://www.ozgrid.com/Excel/autocomplete-validation.htm

if this helps, please click the Yes button.

cheers,
Shane Devenshire

"B. Meincke" <(E-Mail Removed)> wrote in message
news:0DEC8507-D192-48CC-9B37-(E-Mail Removed)...
> I don't know if I'm asking for the impossible. I know that Excel will
> "guess"
> what you are typing based on previously entered values in a field but is
> there a way I can program a column to take those guesses from values in a
> column on another sheet in the active workbook?
>
> My user needs to type street names into a field. These street names must
> be
> typed to exactly match street names in a street name column on another
> sheet
> in the same workbook. I would like it to be so that when she starts typing
> the first few letters of a street name, Excel will 'lookup' what she's
> typing from the list of street names on the other sheet and offer matching
> values for her to choose. Once she clicks to choose them, like the built
> in
> feature, Excel will complete the entry for her.
>
> I hope this makes sense. I don't know how else to describe what I'm
> looking
> for. Thanks in advance for any ideas or advice.
> --
> BJM
> ACE Assistant
> Gary Allan High School

Thank you Shane. I'm actually a little embarrassed that it is so simple. I've
opted to just use the built in validation as my client is not open to the
additional investment of the third party add in you recommended.
--
BJM
ACE Assistant
Gary Allan High School


"Shane Devenshire" wrote:

> Hi,
>
> Since you want exact matches you might look at Data, Validation, List using
> as the list the names in the other field. However, DV, does not provide
> auto complete so you might look at
>
> http://www.contextures.com/xlDataVal10.html
> http://www.ozgrid.com/Excel/autocomplete-validation.htm
>
> if this helps, please click the Yes button.
>
> cheers,
> Shane Devenshire
>
> "B. Meincke" <(E-Mail Removed)> wrote in message
> news:0DEC8507-D192-48CC-9B37-(E-Mail Removed)...
> > I don't know if I'm asking for the impossible. I know that Excel will
> > "guess"
> > what you are typing based on previously entered values in a field but is
> > there a way I can program a column to take those guesses from values in a
> > column on another sheet in the active workbook?
> >
> > My user needs to type street names into a field. These street names must
> > be
> > typed to exactly match street names in a street name column on another
> > sheet
> > in the same workbook. I would like it to be so that when she starts typing
> > the first few letters of a street name, Excel will 'lookup' what she's
> > typing from the list of street names on the other sheet and offer matching
> > values for her to choose. Once she clicks to choose them, like the built
> > in
> > feature, Excel will complete the entry for her.
> >
> > I hope this makes sense. I don't know how else to describe what I'm
> > looking
> > for. Thanks in advance for any ideas or advice.
> > --
> > BJM
> > ACE Assistant
> > Gary Allan High School
>
>