Forum Discussion
Murphy1990
Apr 09, 2021Copper Contributor
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...
- Apr 09, 2021
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.
HansVogelaar
Apr 09, 2021MVP
Where on Sheet2 do you want to copy those cells to?
Murphy1990
Apr 09, 2021Copper Contributor
Hey,
To the same cell on sheet 2
Thanks
James
To the same cell on sheet 2
Thanks
James