Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, [A2]) Is Nothing Then
Dim Dg As Long, Hg As Long
2 Dim Sh As Worksheet, WF As Object, Rng As Range '*'
Rows("6:500").Hidden = False
Sheets("Nhap").Columns("A:F").AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Range("A1:A2"), CopyToRange:=Range("B5:D5"), Unique:=False
Dg = [D500].End(xlUp).Row
Sheets("Xuat").Columns("A:F").AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Range("A1:A2"), CopyToRange:=Range("F5:H5"), Unique:=False
Hg = [h500].End(xlUp).Row
If Dg > Hg Then Hg = Dg Else Dg = Hg
Dg = Hg + 1
Rows("500:" & Dg).Hidden = True
9 Set Sh = ThisWorkbook.Worksheets("DanhMuc")
Set Rng = Sh.[b2].CurrentRegion
Set WF = Application.WorksheetFunction
[b2].Value = WF.VLookup(Target.Value, Rng, 2, False)
[c2].Value = WF.VLookup(Target.Value, Rng, 3, False)
[d2].Value = WF.Sum([d6].Resize(500))
[e2].Value = WF.Sum([H6].Resize(500))
[f2].Value = [e2].Value * IIf([b2].Value = "Mts", 1.2, 1.02)
17 [G2].Value = [c2].Value + [d2].Value - [f2].Value
End If
End Sub