For i = 2 To lastRow ' Bắt đầu từ dòng 2
wsTarget.Cells(8, 14).Offset(0, i - 2).Value = wsSource.Cells(i, 6).Value ' F2 sang N8
wsTarget.Cells(8, 15).Offset(0, i - 2).Value = wsSource.Cells(i, 7).Value ' G2 sang O8
wsTarget.Cells(8, 16).Offset(0, i - 2).Value = wsSource.Cells(i, 8).Value ' H2 sang P8
wsTarget.Cells(8, 17).Offset(0, i - 2).Value = wsSource.Cells(i + 1, 6).Value ' F3 sang Q8
wsTarget.Cells(8, 18).Offset(0, i - 2).Value = wsSource.Cells(i + 1, 7).Value ' G3 sang R8
wsTarget.Cells(8, 19).Offset(0, i - 2).Value = wsSource.Cells(i + 1, 8).Value ' H3 sang S8
Next i