Help with IF>THEN ???? or whatever will work

[Ken F]

Thanks in advance for any help provided.....

I have created an Inspection form that includes 9 worksheets........each
worksheet includes lines of questions that are followed by 3 cells with
pull downs that can be populated with X.........the headers for these cells
are Yes, No, N/A........
Example:

4.3.2 Sprinkler heads appear to be in good condition? __ __ __

Y N N/A

4.3.3 Sprinkler heads appear to be in clean condition? __ __ __


4.3.4 Sprinkler pipes appear to be in good condition? __ __ __



Here is my challenge.........any question on any worksheet that has the
"NO" cell populated, a comment must be made explaining the
answer.........the
comment section is the last worksheet of the document (tab named "SUMMARY")
I have no
idea on how to carry data from the "No" cells to the final worksheet.....so
that, for instance, from the example above, if 4.3.2 and 4.3.4 were answered
NO, I would want Worksheet "Summary" Cell A7 to be populated with content
4.3.2 then when question 4.3.4 is answered NO, Summary worksheet Cell A8 is
populated with 4.3.4..........then, when the user finishes the inspection
form, any items answered NO will have the line numbers listed in an orderly
manner on the SUMMARY worksheet for additional comments

Line# Comments
4.3.2 Second Floor needs replacement
4.3.4 Basement equipment covered with dust/dirt/grime
etc
etc

 

[BrianB]

Something like this in sheet1 ?
=IF(Sheet2!A1="No",Sheet2!B1,"")

Which means "If A1 in sheet2 is "No" then show the contents of cell B
of sheet2, otherwise leave blank"