G
Guest
I do not know how to achieve this requirement.....or even if it is possible.....
I have created an Excel document with 9 worksheets........each worksheet has numerous questions with 3 cells available after the question for answers....example
Cell A10=4.2.4 Cell B10=Customer location free of debris? Cell C,D&E10 has pull down available to populate cell with X
Cells C,D & E 9 are Yes, N/A & No
Whenever a "No" cell is populated, I would like to have the line number (in this case contents of A10) placed on worksheet 10...........as each "No" cell is populated, the coresponding A row value (question #) would be inserted below the previous value on worksheet 10.....
In end user terms....whenever a "No" answer is selected on any of the worksheets, a comment must be made explaining the reason.......the comments should be made on the last worksheet of the document and each comment must reference the question number of the line in which the "No" applies.....so if qustion 7.2.6 yields a "No", the comments page should automatically have 7.2.6 entered with a space for comment. When the user tabs to worksheet 10, All "No" answers are listed and waiting for comments to be manually added.
If this doesnt make sense, I will be happy to rephrase......
Thanks in advance
I have created an Excel document with 9 worksheets........each worksheet has numerous questions with 3 cells available after the question for answers....example
Cell A10=4.2.4 Cell B10=Customer location free of debris? Cell C,D&E10 has pull down available to populate cell with X
Cells C,D & E 9 are Yes, N/A & No
Whenever a "No" cell is populated, I would like to have the line number (in this case contents of A10) placed on worksheet 10...........as each "No" cell is populated, the coresponding A row value (question #) would be inserted below the previous value on worksheet 10.....
In end user terms....whenever a "No" answer is selected on any of the worksheets, a comment must be made explaining the reason.......the comments should be made on the last worksheet of the document and each comment must reference the question number of the line in which the "No" applies.....so if qustion 7.2.6 yields a "No", the comments page should automatically have 7.2.6 entered with a space for comment. When the user tabs to worksheet 10, All "No" answers are listed and waiting for comments to be manually added.
If this doesnt make sense, I will be happy to rephrase......
Thanks in advance