You have to use VBA to do that. I can support that if you provide more details about what are the values you are working with and the rules for setting the related values. A sample file would be ideal.
You have to use VBA to do that. I can support that if you provide more details about what are the values you are working with and the rules for setting the related values. A sample file would be ideal.
Thanks for the help. I have attached a sample file here. The conditions and values are essentially the same as in my earlier post; only the cell addresses are different.
If Option 1 (cell B2) is set to "Yes", the drop down values for Option 2 (cell B3) include both "Yes" & "No".
If Option 1 is set to "No", the only option in the drop down list for Option 2 is "No."
If both Options were set to "Yes" and then Option 1 is changed from "Yes" to "No", I want the value in Option 2 to change automatically to "No".
Option 2's drop down values are listed in the table starting at cell H2.
Thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks