Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. . |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
graphs from multiple worksheet : query | Charts and Charting in Excel | |||
How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
How do I copy page setup from one worksheet & paste into new shee. | Excel Discussion (Misc queries) | |||
Linking items GREATER THAN O on another worksheet in the same Work | Excel Discussion (Misc queries) | |||
Worksheet name and Backward compatibility | Excel Discussion (Misc queries) |