Nadine1988
Board Regular
- Joined
- Jun 12, 2023
- Messages
- 62
- Office Version
- 365
- Platform
- Windows
Hello,
so first of all - this is not about dependent dropdown lists - The dropdown lists in my excel file are already dependent from each other. What I would like to know if it's possible to automatically change what is set in one dropdown when changing something in an other one.
I do have a huge amount of date and I can't put this in one If formula within every dropdown. So to summarize:
Main Dropdown is located in field C33 - There are two dependent Dropdown list in C35 and C46- So if you change C33 after you've changed C35 or C46 i would like the dropdown list in C35 and C46 to adjust automatically to "_Please choose" (which is part of the data list)
Additionally I have 3 dropdown lists each depending on C35 and C46 - (C35: C37, C39 and C41 / C46: C48, C50 and C52) - so if you change C35 and / or C46 the related dropdowns needs to adjust automatically to "_Please choose" again.
And then again. I do have an other dropdown in Field C59 - dependent on the dropdown in C57 and three dropdowns in C61, C63 and C65 depending on the dropdown in C59
I hope this is not too confusing and someone can help me with the code here. I actually don't have any idea and can't find anything when googleing
Thanks for your assistance
Nadine
so first of all - this is not about dependent dropdown lists - The dropdown lists in my excel file are already dependent from each other. What I would like to know if it's possible to automatically change what is set in one dropdown when changing something in an other one.
I do have a huge amount of date and I can't put this in one If formula within every dropdown. So to summarize:
Main Dropdown is located in field C33 - There are two dependent Dropdown list in C35 and C46- So if you change C33 after you've changed C35 or C46 i would like the dropdown list in C35 and C46 to adjust automatically to "_Please choose" (which is part of the data list)
Additionally I have 3 dropdown lists each depending on C35 and C46 - (C35: C37, C39 and C41 / C46: C48, C50 and C52) - so if you change C35 and / or C46 the related dropdowns needs to adjust automatically to "_Please choose" again.
And then again. I do have an other dropdown in Field C59 - dependent on the dropdown in C57 and three dropdowns in C61, C63 and C65 depending on the dropdown in C59
I hope this is not too confusing and someone can help me with the code here. I actually don't have any idea and can't find anything when googleing

Thanks for your assistance

Nadine