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