I am trying to write a code that directs the user to a specific sheet in the workbook depending on a yes or no answer.
So basically there is information that will need to be completed and the information is specific to whether it is a YES or NO. So I want to set up a page where one of the questions is a yes/no question and depending on the answer you will be directed to a specific sheet for data input. With in that sheet there will be drop down lists specific to that sheet. Data that is based on the YES or NO question.