The only way Excel Autocomplete works is if the value has previously been
entered into the same column, and there are no blank cells between the
values (database) and values that you enter now. So you'd have to do a dirty
little workaround...
*******************
~Anne Troy
www.OfficeArticles.com
"njamy" wrote in message
...
I'm using excel to log in customer payments. How can I get autocomplete
to
complete customer names so I won't have to type them over and over? Is
there
a place I can create a data base of the name? Thanks