| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down list from another worksheet
Hi,
I have two worksheets, and I want to create a drop down list on the second sheet from a list of names on the first sheet. Does anyone know how to do this? Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop down list from another worksheet
Select the list on the second sheet and name it. "Mylist" or whatever.
In the Source box of the Data Val wizard enter =Mylist. Hit OK. HTH Regards, Howard "hcronrath" wrote in message ... Hi, I have two worksheets, and I want to create a drop down list on the second sheet from a list of names on the first sheet. Does anyone know how to do this? Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop down list from another worksheet
Watch this 5 min video:
How to setup a data validation drop down list: http://youtube.com/watch?v=t2OsWJijrOM -- Biff Microsoft Excel MVP "hcronrath" wrote in message ... Hi, I have two worksheets, and I want to create a drop down list on the second sheet from a list of names on the first sheet. Does anyone know how to do this? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help Creating a Drop Down List from a List in another worksheet | Excel Discussion (Misc queries) | |||
| Printing a worksheet with a Drop Down List | Excel Worksheet Functions | |||
| Drop Down List from one worksheet to another | Excel Discussion (Misc queries) | |||
| Drop Down list from a different worksheet | Excel Discussion (Misc queries) | |||
| Populating worksheet via a drop down list ! | Excel Worksheet Functions | |||
Linear Mode
