predict text based on cell range?

J

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
 
T

Toyin.Butler

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

HTH

Toy.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Predictive Text based on cell range? 1
Predict based on range or series 1
Set range, perform operation, set new range, repeat 1
Filter based on named range cell - debug help required 3
Find Column Letter - When column header is found 9
Links Based on Cell Values 1
Copy range based on input 1
for every cell search identical in range, not whole column; how? 2

Top