| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down list on other sheet?
I can't have a drop down list refer to a range on another sheet in Excel 2000?
Do more recent versions let you do that? Interesting, instead of programming it to do that, they program it to tell you that you can't do that. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
drop down list on other sheet?
You can use a list on a separate sheet in Data/Validation if you name
the list (say, "MyList"). Then choose Data/Validation, Allow:List, Formula: =MyList In article , dlw wrote: I can't have a drop down list refer to a range on another sheet in Excel 2000? Do more recent versions let you do that? Interesting, instead of programming it to do that, they program it to tell you that you can't do that. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
| how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
| Drop Down List from different sheet | Excel Discussion (Misc queries) | |||
| Value selected on drop down list, look-up on different sheet | Excel Worksheet Functions | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Linear Mode
