Autocomplete based on a different worksheet.
 

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.

Hi
AFAIK this is not possible

--
Regards
Frank Kabel
Frankfurt, Germany

"rv" schrieb im Newsbeitrag
...
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.

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




-----Original Message-----
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.
.

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