Apr 09 2021 02:31 PM
Apr 09 2021 02:36 PM
Where on Sheet2 do you want to copy those cells to?
Apr 09 2021 02:51 PM
Apr 09 2021 02:56 PM
SolutionLet'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.
Apr 09 2021 03:34 PM
Apr 09 2021 03:59 PM
Apr 09 2021 06:17 PM
Apr 09 2021 02:56 PM
SolutionLet'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.