VBA code to insert rows meeting a condition

[BungleNZ]

Hi, I'm trying to insert a bit of code into my existing click button macro to insert a row based on a condition being met and then insert a formula into the resulting blank cell.

Range to look at = L1:L1000

Condition = "=IF(LEFT(R[-1]C,13)=""ORCSW FRM ***"",""insert row below here"",""go to next"")"

Code to insert into blank cell created in column L = "=""ORCSW HDW PNL ""&TEXT(R[-1]C[-3]*0.2,""00000.00"")&RIGHT(R[-1]C,4)"


Assuming this is easy enough to solve, I then want one final line of code to save the text in order in range L1:L1000 to a file called "labour00.txt", but only cells that have a do not equal "" or are not blank.

Thank you in advance for any help you can give.

 

[BungleNZ]

Any ideas anyone?

 

[BungleNZ]

Bump