Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
drop down list
My question: I have two worksheets. One worksheet has several columns. The
second worksheet has one column. I want the information from number 2 worksheet to be in a drop down in a column on my first worksheet. Thanks. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
drop down list
Hi,
You can use Data, Validation for this, but you must name the range in the 1st sheet that contain the items you want on the drop down in the second sheet. 1. Select the range containing the items in sheet 1 then choose Insert, Name, Define and type a name (without spaces) into the Names in workbook box and click OK. Suppose you name it myList. 2. Move to sheet 2, select a cell or range and choose Data, Validation and on the first tab pick List from the Allows drop down. In the Source box enter =myList and click OK. -- Thanks, Shane Devenshire "Sheryl" wrote: My question: I have two worksheets. One worksheet has several columns. The second worksheet has one column. I want the information from number 2 worksheet to be in a drop down in a column on my first worksheet. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
how do I use one drop-list to modify another drop-lists options? | 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) |