Option Explicit: Option Base 1
Dim iJ As Long, iZ As Long
Public lID As Long, lJnt1 As Long [b]
Sub Loc2Cot() [/b]
Dim iDem As Long
Application.ScreenUpdating = False
Sheets("Thanh").Select: lJnt1 = Range("B36525").End(xlUp).Row - 4
Sheets("nut").Select: lID = Range("A36522").End(xlUp).Row - 2
ReDim MDLieu(2 * lJnt1 + 9, 5): ReDim MangID(lID)
[color="blue"] 'Khai báo mãng MDLieu đã # trước [/color]
For iJ = 1 To lID
MangID(iJ) = Range("A" & CStr(iJ + 2)).Value
Next iJ
Sheets("Thanh").Select
For iZ = 1 To lID
For iJ = 5 To lJnt1
If Range("B" & CStr(iJ)).Value = MangID(iZ) Then
iDem = iDem + 1: MDLieu(iDem, 1) = MangID(iZ) '1
MDLieu(iDem, 2) = Range("B" & CStr(iJ)).Offset(0, 1).Value '2
MDLieu(iDem, 3) = Range("B" & CStr(iJ)).Offset(0, -1).Value 'Frame
MDLieu(iDem, 4) = Range("B" & CStr(iJ)).Offset(0, 2).Value 'Sec
MDLieu(iDem, 5) = Range("B" & CStr(iJ)).Offset(0, 9).Value 'Leng
End If
Next iJ, iZ
[color="blue"] 'Thêm đây: [/color]
For iZ = 1 To lID
For iJ = 5 To lJnt1
If Range("C" & CStr(iJ)).Value = MangID(iZ) Then
iDem = iDem + 1: MDLieu(iDem, 1) = MangID(iZ) [color="blue"] ''1 [/color]
MDLieu(iDem, 2) = Range("B" & CStr(iJ)).Value [color="blue"] ' '2 [/color]
MDLieu(iDem, 3) = Range("A" & CStr(iJ)).Value [color="blue"] ''Frame[/color]
MDLieu(iDem, 4) = Range("D" & CStr(iJ)).Value [color="blue"] ''Sec[/color]
MDLieu(iDem, 5) = Range("K" & CStr(iJ)).Value [color="blue"] ''Leng[/color]
End If
Next iJ, iZ
Sheets("KQua").Select
iJ = 6: iDem = 0
Do
iJ = 1 + iJ: iDem = 1 + iDem
If Len(MDLieu(iDem, 1)) < 1 Then Exit Do
Range("D" & CStr(iJ)).Value = MDLieu(iDem, 1)
Range("H" & CStr(iJ)).Value = MDLieu(iDem, 2)
Range("L" & CStr(iJ)).Value = MDLieu(iDem, 3)
Range("M" & CStr(iJ)).Value = MDLieu(iDem, 4)
Range("N" & CStr(iJ)).Value = MDLieu(iDem, 5)
If MDLieu(iDem, 1) <> MDLieu(iDem + 1, 1) Then iJ = iJ + 1 [color="blue"] 'Mới sửa sáng ngày PN! [/color]
Loop
[b]End Sub[/b]