| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
CREATE MULTIPLE DROP DOWN LIST IN SAME WORKBOOK?
Any help is appreciated. Have many pages to workbook. TIME and SPOT are frequent elements in each page - want to create 2 drop down lists - if entering time - can be selected from drop down - if the cell is spot - select from SPOT list - how can I simply have 2 different lists to select from in the same worksheet and use in the entire workbook? thanks in advance |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
CREATE MULTIPLE DROP DOWN LIST IN SAME WORKBOOK?
Use a named range to define your list.
http://www.officearticles.com/excel/...soft_excel.htm You can put the list(s) on a worksheet and even hide the worksheet when you're done if you like. ************ Hope it helps! Anne Troy www.OfficeArticles.com Check out the NEWsgroup stats! Check out: www.ExcelUserConference.com "snarled times" wrote in message ... Any help is appreciated. Have many pages to workbook. TIME and SPOT are frequent elements in each page - want to create 2 drop down lists - if entering time - can be selected from drop down - if the cell is spot - select from SPOT list - how can I simply have 2 different lists to select from in the same worksheet and use in the entire workbook? thanks in advance |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
CREATE MULTIPLE DROP DOWN LIST IN SAME WORKBOOK?
One way by
http://www.contextures.com/xlDataVal02.html -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "snarled times" wrote in message ... Any help is appreciated. Have many pages to workbook. TIME and SPOT are frequent elements in each page - want to create 2 drop down lists - if entering time - can be selected from drop down - if the cell is spot - select from SPOT list - how can I simply have 2 different lists to select from in the same worksheet and use in the entire workbook? thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CREATING MULTIPLE DROP DOWN LISTS IN SAME EXCELWORKBOOK | Excel Discussion (Misc queries) | |||
| Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
| create drop down for address list | Excel Discussion (Misc queries) | |||
| How can I create multiple rows of worksheet tabs in a workbook? | Excel Discussion (Misc queries) | |||
| Refer to seperate workbook for validation list for drop downs? | Excel Discussion (Misc queries) | |||
Linear Mode
