You could add a data validation list to the cells in the column.

Although data validation doesn't support autocomplete, there's a sample
file here that provides a combobox from which you can select one of the
values from the data validation list. In the combobox, you can enable
autocomplete:

http://www.contextures.com/excelfiles.html

Under 'Data Validation', look for 'Data Validation Combobox'

rv wrote:
I know how to enable autocomplete for values in a list. Is it possible to
autocomplete an antry to a cell in a sheet based on list values from a
different sheet? Excel 2000.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html