Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
lTotal = [B65000].End(3).Row - 1
If Target.Column = 2 Then
Rows(Target.Row + 1).Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
bas = Range("A" & lTotal).End(3).Row
Range("A1
" & bas).Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlYes, Orientation:=xlTopToBottom
End If
If Target.Column <> 1 Then
Cells(bas + 2, 1) = Application.CountA(Range("A2:A" & [A65000].End(3).Row))
Cells(bas + 2, 3) = Application.CountA(Range("C2:C" & [A65000].End(3).Row))
Cells(bas + 2, 4) = Application.CountA(Range("D2
" & [A65000].End(3).Row))
End If
Application.EnableEvents = True
End Sub