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