I have an excel file which I need to format.
If a user puts in value "1" in cell B5 then it needs to show a different set of questions in the cells below.
This needs to be repeated for "2" and "3".
So the logic will be to hide and show certain rows of excel data based on the value in the B5.
There is a total of 6 rows that need to updated based on the B5 value. i.e. 6 differenet questions based on the 3 values.
The question answers will then be sourced on the next worksheet.