Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down list
Hi
How can I create a drop down list which is on a separate worksheet but in the same file? The name of the worksheet is Idaunits. And I want the drop down list on a separate worksheet named WCU Sept. Thanks 1I1A 1I1B 1I2 1I3 1I4 1I4A 1I4B 1I5 1I6 1I96 1I97 1I98 1L20 1L40 1L50 1Z2 1Z3 2I1 2I1A 2I1B 2I2 2I3 2I3B 2I4 2I4A 2I4B 2I5 2I6 2I96 2I97 2I98 2L20 2L40 2L50 2Z2 2Z3 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down list
Goto Insert - Name - Define.
Select your range of cells with your list, and give it a name (MyRange). Click Add, Ok out. On your other worksheet, goto Data - Validation - List Input the following: =MyRange Ok out. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "da" wrote: Hi How can I create a drop down list which is on a separate worksheet but in the same file? The name of the worksheet is Idaunits. And I want the drop down list on a separate worksheet named WCU Sept. Thanks 1I1A 1I1B 1I2 1I3 1I4 1I4A 1I4B 1I5 1I6 1I96 1I97 1I98 1L20 1L40 1L50 1Z2 1Z3 2I1 2I1A 2I1B 2I2 2I3 2I3B 2I4 2I4A 2I4B 2I5 2I6 2I96 2I97 2I98 2L20 2L40 2L50 2Z2 2Z3 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down list
Thank you. It worked.
"Luke M" wrote: Goto Insert - Name - Define. Select your range of cells with your list, and give it a name (MyRange). Click Add, Ok out. On your other worksheet, goto Data - Validation - List Input the following: =MyRange Ok out. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "da" wrote: Hi How can I create a drop down list which is on a separate worksheet but in the same file? The name of the worksheet is Idaunits. And I want the drop down list on a separate worksheet named WCU Sept. Thanks 1I1A 1I1B 1I2 1I3 1I4 1I4A 1I4B 1I5 1I6 1I96 1I97 1I98 1L20 1L40 1L50 1Z2 1Z3 2I1 2I1A 2I1B 2I2 2I3 2I3B 2I4 2I4A 2I4B 2I5 2I6 2I96 2I97 2I98 2L20 2L40 2L50 2Z2 2Z3 |
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 dependant on previous 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 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) |