Private Sub Worksheet_Change(ByVal Target As Range)
Dim Arr, dArr(1 To 1000, 1 To 10), I As Long, J As Long, K As Long
Dim lastRow As Long
With Sheet5
lastRow = .Range("C" & Rows.Count).End(xlUp).Row
If lastRow < 7 Then MsgBox "khong co du lieu!": Exit Sub
Arr = .Range("C7:R" & lastRow).Value2
End With
Application.ScreenUpdating = False
If Target.Address = "$F$7" Then '// F7 not F4