ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Drop down list dependant on previous drop down list (https://www.excelbanter.com/excel-discussion-misc-queries/193231-drop-down-list-dependant-previous-drop-down-list.html)

Tenacioushail

Drop down list dependant on previous drop down list
 
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.

Roger Govier[_3_]

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.




All times are GMT +1. The time now is 04:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com