View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Drop down list dependant on previous drop down list

Hi
Debra Dalgleish has some excellent examples of this at her site
http://www.contextures.com/xlDataVal13.html

--
Regards
Roger Govier

"Tenacioushail" wrote in message
...
I am trying to put together a database of building costs that will have a
drop down list that includes such elements as Flooring, Ceilings,
Decorations
etc.

If i pick for example ceilings, i want the next cell to have choices
limited
to Suspended Ceilings, Plastered ceilings, or if i had picked Flooring to
be
limited to Carpet tiles, Carpet Sheet, Vinyl.

Could anyone assist on this

Thanks in advance.