Autocomplete based on a different worksheet.

[Guest]

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.

 

[Frank Kabel]

Hi
AFAIK this is not possible

 

[Mark]

Hi,
Well, it is not impossible. You can write a macro to
include that list of values into your List so that it
becomes part of the Excel list function and Autocomplete
is complete...

- mark

 

[Debra Dalgleish]

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'