[Solved] Code to copy from one column to another based on values

You can do that with a formula in column N

=IF(LEFT(F:F,2)="07",F:F,IF(LEFT(G:G,2)="07",G:G,IF(LEFT(H:H,2)="07",H:H,IF(LEFT(I:I,2)="07",I:I,"-"))))