Previous Topic Next Topic

3 dropdownlists

Solved/Closed
Gouws Posts 45 Registration date Sunday 7 February 2010 Status Member Last seen 15 April 2012 - 7 Jun 2010 à 05:11
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 7 Jun 2010 à 05:56
Hello, Please help
I want to make 3 dropdown lists in Column B2,3,4 and all must work together. In B2 i must have a selection of e.g Building,Person,Road,Tower ,if i choose Person then in B3 i must have a selection of House,Dog,Car,etc if i then choose House in B4 i must be able to choose from say car,alarm,bunk,bed the same for all the other.
All the names in B2 have 10 different items to choose from in B3.
All the names in B3 have 10 different items to choose from in B4 .

TX
G

config>Windows XP / Internet Explorer 8.0</config>
Related:

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
7 Jun 2010 à 05:56
See this
It is for two dropdown, but you can expand it to three


https://ccm.net/forum/affich-269392-dropdown-lists-in-excel-2007