I have a very limited understanding of macro and VBA
I am trying to make a hidden row appear only if the following conditions are met:
1. A specific option is selected from one drop down menu
2.Any of 4 options (mme, lc, isb or cre) are selected from another drop down list which contains multiple other options
2. At least two cells in a range of four cells are populated with "yes"
if not all criteria are met the row should remain hidden.
Any pointers on this would be great as I have been effectively teaching myself from YouTube and excel forums and have hit a wall on this one.
I am trying to make a hidden row appear only if the following conditions are met:
1. A specific option is selected from one drop down menu
2.Any of 4 options (mme, lc, isb or cre) are selected from another drop down list which contains multiple other options
2. At least two cells in a range of four cells are populated with "yes"
if not all criteria are met the row should remain hidden.
Any pointers on this would be great as I have been effectively teaching myself from YouTube and excel forums and have hit a wall on this one.