Tuesday, March 17, 2015

yogi_Pull Into Another Sheet Information About Unsafe Zones And Associated Activities

                                           Google Spreadsheet   Post  #1925
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Mar 16, 2015
question by Clay Rollo:
Formula to pull information from multiple cells to another sheet, based on certain data

   I have a form response sheet for a safety audit.  There are quite a few cells, and many audit teams.  It takes a lot of scrolling back and forth to see all the data.  I need to be able to import any "unsafe" findings, along with the audit team, zone audited, and date of the audit to another sheet.  I only need to see the information if an "unsafe" was reported, and even then, all I want to see is what was unsafe, who found it, when it was found, and where.  I have made a shorter example sheet to hopefully help explain what I mean, you can see it HERE.  Please note that there are several different "topics" to the audit (i.e. general safety observations, forklift safety, employee behavior, etc. and each topic has a comment section at the end....).  I would like to import the comments only if there is an "unsafe" in that section.....

   Thank you in advance for any help you can provide, I appreciate it!

To clarify (or maybe I've just thought it through a little more), if the information below is on sheet "Form Responses 1", and any cell (E2 for example) contains the word "unsafe", then I want to copy the information in columns A-C for that row, as well as the header for the column with "unsafe" (E1 in this example) to a second sheet, i.e. a sheet called "Unsafe Findings".  In addition, I would also like to copy over any comments (G2 in this example) to the other sheet, but only if there is an "unsafe" in that topic (in my original question I mentioned that I have several "topics" separated by comment sections)....

Again, I REALLY appreciate any help