Previous Topic Next Topic

3 dropdownlists

Solved/Closed
Gouws Posts 45 Registration date Sunday February 7, 2010 Status Member Last seen April 15, 2012 - Jun 7, 2010 at 05:11 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 7, 2010 at 05:56 AM
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

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 7, 2010 at 05:56 AM
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
0