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 th...
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.
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.
