predict text based on cell range?

[J.W. Aldridge]

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

 

[Toyin.Butler]

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

HTH

Toy.