Sub Copy()
Dim i, j, k, t, m: i = 1: j = 1: t = 1
[COLOR=seagreen][COLOR=seagreen]'Kiem tra dong trong sheet2 dong j cot 1[/COLOR]
[/COLOR]Do
If Sheet2.Cells(j, 1) = "" Then
[COLOR=seagreen]' neu trong gan' k = j
[/COLOR] k = j
[COLOR=seagreen] ' kiem tra sheet1 neu trong thi` thoat vong do
' nguoc lai thi in qua sheet2[/COLOR]
Do
If Sheet1.Cells(i, 1) = "" Then
Exit Do
Else
Sheet2.Cells(k, 1) = Sheet1.Cells(i, 1)
Sheet2.Cells(k, 2) = Sheet1.Cells(i, 2)
[COLOR=seagreen]' Tang len 1 dong
[/COLOR] k = k + 1
End If
i = i + 1
Loop
[COLOR=seagreen] ' Gan m = k de chon dong tiep theo cua k
[/COLOR] m = k
[COLOR=seagreen]' neu sheet1 cot 5 = "" thoat vong do
' nguoc lai thi in qua qua sheet2[/COLOR]
Do
If Sheet1.Cells(t, 5) = "" Then
Exit Do
Else
Sheet2.Cells(m, 1) = Sheet1.Cells(t, 5)
Sheet2.Cells(m, 2) = Sheet1.Cells(t, 6)
m = m + 1
End If
t = t + 1
Loop
End If
Exit Do
j = j + 1
Loop
End Sub