CREATING MULTIPLE DROP DOWN LISTS IN SAME EXCELWORKBOOK

I would appreciate any help.
Have workbook of several pages - have 2 information coloums that are used in
many segments of the worksheets - (tracking ad spots that air on certain
stations and times)
that I would llike to create 2 different drop down boxes for (1) time (2)
spot# -
can I create 2 drop down list - one TIME, one SPOT# so when I right click on
the cell I can select either and get that drop down menu so I can apply to
any cell?
so if I click on TIME - I will get the list of time or Sport and get the
list of spot #'s - I am not VB experienced and want to keep it simple
thanks in advance

See http://www.xldynamic.com/source/xld.Dropdowns.html

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"snarled times" <snarled [email protected]> wrote in message
news:[email protected]...
> I would appreciate any help.
> Have workbook of several pages - have 2 information coloums that are used
in
> many segments of the worksheets - (tracking ad spots that air on certain
> stations and times)
> that I would llike to create 2 different drop down boxes for (1) time (2)
> spot# -
> can I create 2 drop down list - one TIME, one SPOT# so when I right click
on
> the cell I can select either and get that drop down menu so I can apply to
> any cell?
> so if I click on TIME - I will get the list of time or Sport and get the
> list of spot #'s - I am not VB experienced and want to keep it simple
> thanks in advance