transfer specific data that meet a selected criterion to be transferred to another sheet

[bustosjuan]

Helo to all experts in this forum. I am very new on this and more new in excel for the level I need for my project. I hope somene could help me on this issue.
I have in an excel document I have called (Inspection Format SHARED FORUM). In this file there are six worksheets defined as follow: (I have highlighted the sheet I need to be linked to transfer data)
Sheet 1 = Planned Inspection Form
Sheet 2 = Hazard Identified
Sheet 3 = Report
Sheet 4 = Severity
Sheet 5 = Shared
Sheet 6 = New Data Enter
I guessed I found the way to share my excel document. I have a url link but the system of this forum do not let me share the link by now.

Sheet 5 (Shared) I have three basic columns all over the sheet.
Columns A, B and C.
Column A contains the CODES
Column B the Description of each code and
Column C the scale or value defined for each code selected during the inspection.
The Scale or Value is selected from a list from "0, 1 and N/A) where:
0 = Unacceptable (Means, it needs an action taken)
1 = Satisfactory
N/A = Not Applicable

Any CODE/Description that get scale selection = 0 need an action taken that would be added in the Sheet 2 (Hazard Identified)

Sheet 2 (Hazard Identified) I want to focus just in column A and B:
Column A = "CODE" Here, Starting in Cell A15 I would like that any Code from Sheet 5 (Shared) that get a selection value =0 automatically be transferred to Sheet 2 (starting in Cell A15). So, if in Sheet 5 (Shared) were selected 10 codes = 0 then each code selected =0 be transferred to sheet 5 (Shared) as separate code starting in cell A15 and so on (A15, A16, A17 ...). The same with Column B in sheet 2 (Hazard Identified)
Column B = Deficiencies/Hazard Identified. Here, any Description in Sheet 5 associated with the CODES that got a selection value = 0 automatically be transferred to sheet 2 in the column called Deficiencies/Hazard Identified starting in the cell B15. and so on (B15, B16, B17 ...).

My expected result is that any code and description that get a value = o in sheet 5 (Shared) be transferred automatically to sheet 2 (Hazard Assessment). In other words, I just need in sheet 2 all the codes that got value = o which are the ones that need an action taken to follow. If all codes get value = 1 or N/A then nothing will appear in Sheet 2 because Value = 1 means all elements inspectors are satisfactory and do not need any action taken.

I hope to have explained myself well and to have made the process of sharing the sheet well also because this technology is a bit complicated but fascinating.
Thanks in advance to whom will be helping me to solve this project.

[Special-K]

Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.

[bustosjuan]

Thank you,
I have Post (Attached in the Manager Attachment link) a sample spreadsheet (Sheet 1) with expected results (Sheet 2).
I hope it works.

Juan

[shukla.ankur281190]

Try

A2

Please Login or Register  to view this content.

Copy towards column B and down!

[bustosjuan]

Thank you very much. It worked but it just transfer the codes whose value =0 but it does not transfer the description of each code. Could youe help me with it as well, please?

Thanks a lot in advance.
Juan

[shukla.ankur281190]

Same formula need to copy for description too

[bustosjuan]

Thank you VERY MUCH. You ROCK. It works PERFECTLY. Just a question, where could I learn to do such things you did? I mean, I would like to lear to do these things in Excel.

Juan

[shukla.ankur281190]

If you really want to learn excel just apply each thing what you learn daily and be regular in Excel forum. You will learn many techniques daily.

[bustosjuan]

I Will do it. Thanks once again. I spent many many hours trying to do the project and I could not do it. I am so amazed with your knowledge.