Sub TronNhatKy()
Dim nArr As Variant, kArr As Variant, i As Long, k As Long, Er As Long
Dim NoidungCV As String, Thoitiet As String, NL As String, ThietbiTC As String
NoidungCV = "N" & ChrW$(7897) & "i c" & ChrW$(244) & "ng vi" & ChrW$(7879) & "c thi c" & ChrW$(244) & "ng trong ng" & ChrW$(224) & "y:"
Thoitiet = "Th" & ChrW$(7901) & "i ti" & ChrW$(7871) & "t:"
NL = "Nh" & ChrW$(226) & "n l" & ChrW$(7921) & "c: "
ThietbiTC = "Thi" & ChrW$(7871) & "t b" & ChrW$(7883) & " thi c" & ChrW$(244) & "ng: "
With Sheets("GhiNhatKy") 'lay du lieu NK chi tiet
nArr = .Range("A6:B" & .Range("B65535").End(3).Row).value
End With
ReDim kArr(1 To UBound(nArr), 1 To 6)
k = 1
kArr(k, 1) = "Ngày"
kArr(k, 2) = Thoitiet
kArr(k, 3) = NL
kArr(k, 4) = ThietbiTC
kArr(k, 5) = NoidungCV
For i = 1 To UBound(nArr)
If nArr(i, 1) <> Empty Then
k = k + 1
kArr(k, 1) = nArr(i, 1)
'
kArr(k, 2) = Replace(nArr(i, 2), Thoitiet, "")
Else
If Left(nArr(i, 2), Len(NL)) = NL Then
kArr(k, 3) = Replace(nArr(i, 2), NL, "")
ElseIf Left(nArr(i, 2), Len(ThietbiTC)) = ThietbiTC Then
kArr(k, 4) = Replace(nArr(i, 2), ThietbiTC, "")
ElseIf Left(nArr(i, 2), Len(NoidungCV)) = NoidungCV Then
Else
If kArr(k, 5) = Empty Then
kArr(k, 5) = nArr(i, 2)
Else
If nArr(i, 2) <> Empty Then kArr(k, 5) = kArr(k, 5) & ChrW(10) & nArr(i, 2)
End If
End If
End If
Next i
If k Then
With Sheets("Nhatky_dangcot")
Er = .Range("A65535").End(3).Row + 1
.Range("A1:E" & Er).ClearContents
.Range("A1:E" & Er).Borders.LineStyle = xlNone
With .Range("A1").Resize(k, 5)
.value = kArr
.WrapText = True
.HorizontalAlignment = xlJustify
End With
End With
End If
End Sub