| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
drop down list location
can the data for a drop down list be on another sheet in the workbook or
even in another workbook .... If possible what is the process TIA |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
drop down list location
You can use a list on a different sheet in the workbook, if you name the
range of cells that contains the list. http://www.contextures.com/xlNames01.html nowhereman wrote: can the data for a drop down list be on another sheet in the workbook or even in another workbook .... If possible what is the process TIA -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
drop down list location
Insert =Name=Define
Name: List1 (or appropriate name) RefersTo: =Sheet3!$A$1:$A$10 click the Add button now in the data validation, when you select the list option, for the source, put in =List1 -- Regards, Tom Ogilvy "nowhereman" wrote in message . 50... can the data for a drop down list be on another sheet in the workbook or even in another workbook .... If possible what is the process TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| drop down list based on other drop down list pick | Excel Discussion (Misc queries) | |||
| Drop Down List Location Question | Excel Discussion (Misc queries) | |||
| Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
| Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
![nowhereman[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
