Private Sub CommandButton1_Click()
Application.ScreenUpdating = False
Range("C3:C9").FormulaR1C1 = "=LEFT(RC1,SEARCH(""/"",RC1)-1)*10000+MID(RC1,SEARCH(""/"",RC1)+1,4)*1"
Range("A3:C9").Sort Key1:=Range("c3"), Order1:=xlAscending
Range("C3:C9").ClearContents
End Sub
Private Sub CommandButton2_Click()
Application.ScreenUpdating = False
Range("C3:C9").FormulaR1C1 = "=LEFT(RC1,SEARCH(""/"",RC1)-1)*10000+MID(RC1,SEARCH(""/"",RC1)+1,4)*1"
Range("A3:C9").Sort Key1:=Range("c3"), Order1:=xlDescending
Range("C3:C9").ClearContents
End Sub