Copying Multiply cells from an activated text

[Murphy1990]

Good evening all,

I have come to ask a question regarding a requirement I need, we bare with me as my explanation might sound complicated, here it goes...

I have a row of 8 cells with data in them on sheet 1
The last cell of the row will either have a Pass or Fail in it.
If it is a Fail I would like to automatically copy cells 1,3,4,5 and 8 to sheet 2.

Hope this makes sense and there is a solution to my requirement.

Thanks

James

[#2]

@Murphy1990 

Where on Sheet2 do you want to copy those cells to?

[#3]

Hey,

To the same cell on sheet 2

Thanks

James

[#4 · Accepted solution]

@Murphy1990 

Let's say that the cells on the data sheet are A1:H1.

Enter the following formula in A1 on the other sheet:

=IF('Sheet 1'!$H$1="FAIL",'Sheet 1'!A1)

where Sheet 1 is the name of the data sheet.

Fill to the right to cell H1.

Finally, clear the cells B1, F1 and G1.

[#5]

@Hans Vogelaar 

Thank you very much this has worked 

Appreciate your time on this

Thanks

James

[#6]

An added query please... if the value is false, what do I need to put to have a blank cell and not have it come up with FALSE?

Thanks

James

[#7]

There's an optional third argument for the if function - you should be able to use "".
=IF('Sheet 1'!$H$1="FAIL",'Sheet 1'!A1,"")