Hi Denis and thanks for the suggestion which sounded like what I needed, however it brings up another problem:
The names to be entered come written on hardcopy documents in various forms like "John Doe", "J. Doe", "J Doe" etc. In other words, If the operator doesn´t remember how exactly John Doe is registered in the name-list, it will be a problem.
The ideal solution would be: The operator starts typing a name. With the first letter typed, a window opens with all the names starting with that letter. As typing progresses, the number of options will reduce. At any point the operator can click on the correct name to be entered.
This feature exists in some other software but I don´t think it is available in Excel.
Maybe I´ll just have to face the facts and write a macro to do just that!
Thanks again!
Rolf