ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Linking Drop down menus (SubCategoies) (https://www.excelbanter.com/excel-discussion-misc-queries/141232-linking-drop-down-menus-subcategoies.html)

mpenkala

Linking Drop down menus (SubCategoies)
 
Hi all,

Is it possible to have a drop down list in Column "B" which differs
depending on what you choose from a drop down list in Column "A"??

Ex.

Column A is a drop down field. You can choose "Floor" or "Wing"
If "Floor" is chosen, the Column B (which is also drop down) gives the
option of chosing "1st floor, 2nd floor, 3rd, floor or All"

If "Wing" is chosed, the options would be "A, B, C or D"

Thanks for your help,
Matt

Pank

Linking Drop down menus (SubCategoies)
 
I asked the same question sometime ago and was pointed to the following
greate site.

http://www.contextures.com/tiptech.html



"mpenkala" wrote:

Hi all,

Is it possible to have a drop down list in Column "B" which differs
depending on what you choose from a drop down list in Column "A"??

Ex.

Column A is a drop down field. You can choose "Floor" or "Wing"
If "Floor" is chosen, the Column B (which is also drop down) gives the
option of chosing "1st floor, 2nd floor, 3rd, floor or All"

If "Wing" is chosed, the options would be "A, B, C or D"

Thanks for your help,
Matt


Pank

Linking Drop down menus (SubCategoies)
 
I asked the same question some ago and was pointed to the following site:-

http://www.contextures.com/tiptech.html

"mpenkala" wrote:

Hi all,

Is it possible to have a drop down list in Column "B" which differs
depending on what you choose from a drop down list in Column "A"??

Ex.

Column A is a drop down field. You can choose "Floor" or "Wing"
If "Floor" is chosen, the Column B (which is also drop down) gives the
option of chosing "1st floor, 2nd floor, 3rd, floor or All"

If "Wing" is chosed, the options would be "A, B, C or D"

Thanks for your help,
Matt



All times are GMT +1. The time now is 01:52 PM.

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