software

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

Use a named range to define your list.
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

quot;snarled timesquot; gt; wrote in message
...
gt;
gt; Any help is appreciated.
gt; Have many pages to workbook. TIME and SPOT are frequent elements in each
gt; page - want to create 2 drop down lists - if entering time - can be
gt; selected
gt; from drop down - if the cell is spot - select from SPOT list - how can I
gt; simply have 2 different lists to select from in the same worksheet and use
gt; in
gt; the entire workbook?
gt; thanks in advance
One way by

www.contextures.com/xlDataVal02.html

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;snarled timesquot; gt; wrote in message
...
gt;
gt; Any help is appreciated.
gt; Have many pages to workbook. TIME and SPOT are frequent elements in each
gt; page - want to create 2 drop down lists - if entering time - can be
gt; selected
gt; from drop down - if the cell is spot - select from SPOT list - how can I
gt; simply have 2 different lists to select from in the same worksheet and use
gt; in
gt; the entire workbook?
gt; thanks in advance