Sub Main()[INDENT]Dim Arr(1 To 20000, 1 To 6)[/INDENT]
[INDENT]Dim Rng As Range, DongCuoi As Long, Makh As String, k As Long, TuNgay, DenNgay[/INDENT]
[INDENT]Sheet9.Range("A12:Z100000").Clear[/INDENT]
[INDENT] Makh = UCase(Sheet9.Range("E5").Value)[/INDENT]
[INDENT] TuNgay = Sheet9.Range("B5").Value[/INDENT]
[INDENT] DenNgay = Sheet9.Range("B6").Value[/INDENT]
[INDENT] k = 0[/INDENT]
[INDENT] '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''[/INDENT]
[INDENT] DongCuoi = Sheet2.Range("A65000").End(xlUp).Row[/INDENT]
[INDENT] Set Rng = Sheet2.Range("A2:P" & DongCuoi)[/INDENT]
[INDENT] Call TrichLoc(Arr, Makh, TuNgay, DenNgay, Rng, k, DongCuoi, 2, 1, 4, 15, 16)[/INDENT]
[INDENT] ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''[/INDENT]
[INDENT] k = k + 1 'chua ra dong trong[/INDENT]
[INDENT] ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''[/INDENT]
[INDENT] DongCuoi = Sheet5.Range("A65000").End(xlUp).Row[/INDENT]
[INDENT] Set Rng = Sheet5.Range("A1:G" & DongCuoi)[/INDENT]
[INDENT] Call TrichLoc(Arr, Makh, TuNgay, DenNgay, Rng, k, DongCuoi, 1, 2, 3, 6, 7)[/INDENT]
[INDENT] ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''[/INDENT]
[INDENT] k = k + 1 'chua ra dong trong[/INDENT]
[INDENT] ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''[/INDENT]
[INDENT] DongCuoi = Sheet11.Range("B65000").End(xlUp).Row[/INDENT]
[INDENT] Set Rng = Sheet11.Range("A1:G" & DongCuoi)[/INDENT]
[INDENT] Call TrichLoc(Arr, Makh, TuNgay, DenNgay, Rng, k, DongCuoi, 2, 1, 4, 6, 10)[/INDENT]
[INDENT] ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''[/INDENT]
[INDENT] Sheet9.Range("A12").Resize(k, 6).Value = Arr[/INDENT]
End Sub