Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]() 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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |