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