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 |
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 |
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 |
All times are GMT +1. The time now is 02:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com