Copy/paste value in Column based on formula in another

[chrysti]

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!

 

[chrysti]

The easier summary is I want to look at what is in column M1 and if it is a "N", then I want to paste as values the formulas in BA1:BG1, then move to the next row. Do the same thing, then move to the next row, until I have no more data, the list can be a different size so I need a loop or something that will stop when the data stops.

Thanks

 

[abdulbasitb]

To confirm the problem has been understood, do you want each row in BA7:BG10000 to have it's formula converted to value when the same row in column M has the value "N"?

If that's a yes, you can copy the solution you get to do the same for "Y" and "S".
If I'm not wrong, you'd run the macro for each of the three cases separately ("N", "Y" or "S") at different times.