Hi JP - problem there is that it won't show you unique entries - it will show
your list as everything you have entered in that column, and it could also
add unwanted entries into the list. That is why the easiest way would be
enter your list of known entries elsewhere.

"JP" wrote:

OK, what about a dynamic named range in the same column as you are
doing the data entry, then data validation on the entire column? As
soon as you typed something in the column, it would be added to the
dropdown list. At least, that is my theory, completely untested of
course.

--JP

On Apr 2, 8:02 pm, Gord Dibben <gorddibbATshawDOTca wrote:
My first thought, but OP doesn't want to use that feature.

Gord



On Wed, 2 Apr 2008 15:35:02 -0700 (PDT), JP wrote:
What about

ToolsOptionsEdit tab, check "Enable AutoComplete for cell values"

?