Dim Vung, I, J, kK, Mg, TachDm, TachMau, Tong, K, A, B
Dim rng As Range, dkrg As Range
If Not Intersect(Target, Range([K132], [K10000].End(xlUp))) Is Nothing Or Not Intersect(Target, Range([AI132], [AI10000].End(xlUp))) Is Nothing Then
If ActiveCell.Interior.ColorIndex = 6 Then
MsgBox "Ban da chon O nay roi"
Else
Vung = ActiveCell.Offset(, -3).Resize(, 14)
Tong = Tong + Len(ActiveCell) - Len(Replace(ActiveCell, "+", "")) + 1
ReDim Mg(1 To Tong, 1 To 7)
TachDm = Split(ActiveCell, "+")
TachMau = Split(Vung(1, 1), "/")
For J = LBound(TachDm) To UBound(TachDm)
K = K + 1
Set rng = ThisWorkbook.Sheets(1).Range("A1:A50")
Set dkrg = rng.Find((Vung(1, 12)), , xlFormulas, xlWhole) Mg(K, 1) = TachDm(J): Mg(K, 2) = TachMau(J): Mg(K, 3) = Vung(1, 12): Mg(K, 4) = Vung(1, 11): Mg(K, 5) = IIf(Mg(K, 3) <> dkrg, Vung(1, 14), 1 / Vung(1, 14)): Mg(K, 6) = Range("AJ108"): Mg(K, 7) = Range("P112")
Next J
ActiveCell.Interior.ColorIndex = 6
Dim Ws As Worksheet
Set Ws = Application.Workbooks("dulieu_tho.xlsm").Worksheets("dulieu_tho")
With Ws.[B1000].End(xlUp)(2)
If .Row = 7 Then
.Offset(, -1) = 1
Else
.Offset(, -1) = 1 + Application.WorksheetFunction.Max(Ws.Range((Ws.[B5]), (Ws.[B10000].End(xlUp))).Offset(, -1))
End If
End With
Ws.[B1000].End(xlUp)(2).Resize(K, 7) = Mg
Application.Workbooks("dulieu_tho").Save
End If
End If
Set Ws = Nothing
Exit Sub
End Sub