Microsoft Excel - Visual Basic Code help

I have a MS Excel workbook that I use on a daily basis. (screen grab attached). I have a job number in column A that automatically sorts A-Z each time I create a new entry. This is achieved using some advice I found on the internet.... Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next If Not Intersect(Target, Range("A2:A200")) Is Nothing Then Range("A1").Sort Key1:=Range("A200"), _ Order1:=xlAscending, Header:=xlYes, _ OrderCustom:=1, MatchCase:=False, _ Orientation:=xlTopToBottom End If End Sub What I would like to do is add some more conditions to this. In column L I have a "completed" value - I type YES once the job is completed and conditional formatting turns it green In column O I have an "archive" value - I Type YES once I am done with the job. I would like the sheet to automatically sort my data by... Column A A-Z with where there is no values in L & O then, Any rows with values in L then, any rows with values in O If you can please paste the code in to your proposal. First response with code that works I'll award & pay