predict text based on cell range?
 

predict text based on range name?

Is there any way to set the predictive text for a column to refer to a
particular range.
Example: I have a list of codes hidden in column E range named
"codelist".

sam123
sue123
sal123
tom123
tim123
toe123



Whenever someone else comes and begins to type into A1,

sam

I need the cell to search the range and autofill / predict that they
are going to type in "sam123" and finish the text for them.

i know that excel does this sometimes on its own, but i am looking to
ensure that this happens, and want to control it by giving it a
definite reference to search and predict.

thanx

predict text based on cell range?
 

Try Data Validation - you can tell the validation criteria to look at
a list which would be your codelist.

HTH

Toy.