J
Junkyard Engineer
I have a list of question in 2 sheets within the same workbook.
Those questions are risk evaluation for projects but depending on 5
criterias, project risk evaluation is modulated in 3 categories : low,
medium and high risk. In the case of Low risk, the first sheet is skipped
altogether and only certain questions on sheet 2 must be answered.
For medium risk, certain question of sheet 1 and 2 must be answered
For High risk, all questions of both sheets must be answered.
For low and medium risk, the questions are not necessarely sequential, i.e.
Q1, 3, 34, 45, etc...
Once answered, I already have a vba code taking all High risk evaluation
questions and copy them into a third sheet which is the contingency planning
for those risk.
MY PROBLEM / QUESTION : When the Evaluation Agent comes in the workgroup, I
want to have a first page interface where he must first answer those 5
questions to evaluate which category the project falls in. Then
automatically or by the push of a button, a questionnaire will popup asking
all questions identified in the appropriate risk group. Once the
questionnaire is answered, the vba code for contingency planning is
automatically executed and the agent is presented with this 3rd sheet.
Can this be done ? (I suppose yes) How ? Is there already an example
somewhere where I can elaborate and taylor to my need ? Of course, results
should be copied into each appropriate cells. Down the road, I plan to print
a summary of those questions/answers but I'm not there yet.
Thanks for any help you can provide me !
Those questions are risk evaluation for projects but depending on 5
criterias, project risk evaluation is modulated in 3 categories : low,
medium and high risk. In the case of Low risk, the first sheet is skipped
altogether and only certain questions on sheet 2 must be answered.
For medium risk, certain question of sheet 1 and 2 must be answered
For High risk, all questions of both sheets must be answered.
For low and medium risk, the questions are not necessarely sequential, i.e.
Q1, 3, 34, 45, etc...
Once answered, I already have a vba code taking all High risk evaluation
questions and copy them into a third sheet which is the contingency planning
for those risk.
MY PROBLEM / QUESTION : When the Evaluation Agent comes in the workgroup, I
want to have a first page interface where he must first answer those 5
questions to evaluate which category the project falls in. Then
automatically or by the push of a button, a questionnaire will popup asking
all questions identified in the appropriate risk group. Once the
questionnaire is answered, the vba code for contingency planning is
automatically executed and the agent is presented with this 3rd sheet.
Can this be done ? (I suppose yes) How ? Is there already an example
somewhere where I can elaborate and taylor to my need ? Of course, results
should be copied into each appropriate cells. Down the road, I plan to print
a summary of those questions/answers but I'm not there yet.
Thanks for any help you can provide me !