SiddharthRout has helped me write a great routine selection using drop down boxes to select the correct choice and then subset the questions. However, in order to actually implement this, I need help with a problem with the dropdown box. I need a little code in the dropdown macro that only allows the choices in either Category or Type to be seen if the "combination" exists….either way. In other words, if you select “C” in Column C, then the only choice you would have is “1”. If you select Type “3” then only “A” and “B” will show in the dropdown.
Good luck! And “Thanks in advance…….”