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
4479
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 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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