I have a formula in column M, which returns a "N", "Y", or "S"
=IFERROR(IFERROR(IF(MATCH($H9,SW!$C$1:$C$20000,0),"S/W"),(IF(INDEX('Line Plan'!$A$1:$CA$20000,MATCH($H9,'Line Plan'!$Q$1:$Q$20000,0),MATCH(M$7,'Line Plan'!$A$4:$CA$4,0))="No","N",INDEX('Line Plan'!$A$1:$CA$20000,MATCH($H9,'Line Plan'!$Q$1:$Q$20000,0),MATCH(M$7,'Line Plan'!$A$4:$CA$4,0))))),"")
I have formulas in Columns BA-BG (BA7:BG10000) that I want to paste values in based on if Column M's formula result
I want to paste as values any cells in BA-BG that are labeled "S" in column M
At a later moment, I want to paste as values and cells in BA-BG that are labeled "N" in column M
And last same thing with "Y" at a different time
The range can also vary from 200 to 10000 rows of information
Last I would like to paste my formulas back in when my sheet needs to be reset in columns BA-BG, can I paste the formula in cell BA1 and have it copy to BA7:BA10000 based on cells that are filled with the master number in column H?
Thanks in advance for the help!
=IFERROR(IFERROR(IF(MATCH($H9,SW!$C$1:$C$20000,0),"S/W"),(IF(INDEX('Line Plan'!$A$1:$CA$20000,MATCH($H9,'Line Plan'!$Q$1:$Q$20000,0),MATCH(M$7,'Line Plan'!$A$4:$CA$4,0))="No","N",INDEX('Line Plan'!$A$1:$CA$20000,MATCH($H9,'Line Plan'!$Q$1:$Q$20000,0),MATCH(M$7,'Line Plan'!$A$4:$CA$4,0))))),"")
I have formulas in Columns BA-BG (BA7:BG10000) that I want to paste values in based on if Column M's formula result
I want to paste as values any cells in BA-BG that are labeled "S" in column M
At a later moment, I want to paste as values and cells in BA-BG that are labeled "N" in column M
And last same thing with "Y" at a different time
The range can also vary from 200 to 10000 rows of information
Last I would like to paste my formulas back in when my sheet needs to be reset in columns BA-BG, can I paste the formula in cell BA1 and have it copy to BA7:BA10000 based on cells that are filled with the master number in column H?
Thanks in advance for the help!