| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create Drop Down Box populated by a List
Would someone please tell me if I can Create a Drop Down Box populated by a
List from another Worksheet which will Select an item from the Drop Down Box populated by the List from the other Worksheet as Input a given Cell. The Drop Down Box should appear and work that way for any selected Cell. thanks, Ted |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create Drop Down Box populated by a List
Hi Ted,
You will need to name the list from the other sheet. So, select the list, name it and then in the data valadation allow list and in source box enter =TheNameOfTheList. HTH Regards, Howard "Ted_MD" wrote in message ... Would someone please tell me if I can Create a Drop Down Box populated by a List from another Worksheet which will Select an item from the Drop Down Box populated by the List from the other Worksheet as Input a given Cell. The Drop Down Box should appear and work that way for any selected Cell. thanks, Ted |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro button to print sheets populated from drop-down list | Excel Discussion (Misc queries) | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| Drop-down list Populated by a Subset of a larger list | Excel Worksheet Functions | |||
| Can I create a drop-down list that will reference other drop-down | Excel Worksheet Functions | |||
| Can a cell have a drop down list and can also be auto populated | Excel Worksheet Functions | |||
Hybrid Mode
