Predictive Text based on cell range?

J

J.W. Aldridge

Is there any way to set the predictive text for a column/cell to refer
to a range?

Example:

My list is in Column E. (E1:E50)

Mary
Bob
James
Larry
Kevin

Whenever someone begins typing a name in A1, it searches and finishes
the name.

Kev


I know that Excel predicts sometimes, but not consistent. I want to
predict based on a set criteria.
 
B

Bill Renaud

Why not simply use Data Validation for cell A1, and have it obtain its list
from range $E$1:$E$50? See the Validation command in the Data menu (Excel
2000).
 

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

predict text based on cell range? 1
Predict based on range or series 1
Macro to Format Multiple Sheets based on "Master" Format 0
Naming non-contigent cells with vba 5
Finding last constant in range 1
sort dynamic range on active cell 3
Combining Text based on Values 8
Using VBA to Copy Ranges to a PreSet Dim formula AND Cell Propertys. 0

Top