Forum Discussion
Solved
Copying Multiply cells from an activated text
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
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
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.
6 Replies
Where on Sheet2 do you want to copy those cells to?
- Hey,
To the same cell on sheet 2
Thanks
JamesLet'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.
