Nhờ Anh/Chị xem lại đoạn code (module 4) sau giúp em, chạy hơi bị chậm khi xử lý cột "G" sheet "tanghanmuc 2024". em cảm ơn ạ
"
Sub tanghanmuc2024()
Dim shdata2024 As Worksheet
Dim i As Long
Dim y As Long
Dim lr As Long
Dim arr() As Long
Dim t
t = Timer
Set shdata2024 = ThisWorkbook.Sheets("data2024")
For i = 2 To 12098
With shdata2024
lr = .Range("AG" & Rows.Count).End(xlUp).Row
Cells(i, 7) = WorksheetFunction.SumIfs(.Range("AG3:AG" & lr), .Range("y3:y" & lr), Cells(i, 2), .Range("b3:b" & lr), Cells(i, 1))
End With
Next
MsgBox Timer - t
End Sub
Sub xoadulieu()
Range("G2:G12908").ClearContents
End Sub"
"
Sub tanghanmuc2024()
Dim shdata2024 As Worksheet
Dim i As Long
Dim y As Long
Dim lr As Long
Dim arr() As Long
Dim t
t = Timer
Set shdata2024 = ThisWorkbook.Sheets("data2024")
For i = 2 To 12098
With shdata2024
lr = .Range("AG" & Rows.Count).End(xlUp).Row
Cells(i, 7) = WorksheetFunction.SumIfs(.Range("AG3:AG" & lr), .Range("y3:y" & lr), Cells(i, 2), .Range("b3:b" & lr), Cells(i, 1))
End With
Next
MsgBox Timer - t
End Sub
Sub xoadulieu()
Range("G2:G12908").ClearContents
End Sub"