Dim
i
As
Integer
Dim
wbOTA
As
Workbook
Dim
wsOTA
As
Worksheet
Dim
wsBS
As
Worksheet
Sub
CopyBS()
Dim
neui
Set
wbOTA = ThisWorkbook
Set
wsOTA = wbOTA.Worksheets(
"OTA"
)
Set
wsBS = wbOTA.Worksheets(
"BS"
)
neui = 4
i = 4
z = 3
Do
While
z < 600
Do
While
i < 200
If
wsOTA.Cells(i, 1).Value = wsBS.Cells(z, 6).Value
Then
wsOTA.Cells(i, 2).Value = wsBS.Cells(z, 9).Value
wsOTA.Cells(i, 3).Value = wsBS.Cells(z, 7).Value
wsOTA.Cells(i, 4).Value = wsBS.Cells(z, 12).Value
wsOTA.Cells(i, 6).Value = wsBS.Cells(z, 19).Value
wsOTA.Cells(i, 7).Value = wsBS.Cells(z, 20).Value
wsOTA.Cells(i, 8).Value = wsBS.Cells(z, 21).Value
wsOTA.Cells(i, 9).Value = wsBS.Cells(z, 22).Value
wsOTA.Cells(i, 12).Value = wsBS.Cells(z, 23).Value
wsOTA.Cells(i, 14).Value = wsBS.Cells(z, 24).Value
wsOTA.Cells(i, 15).Value = wsBS.Cells(z, 25).Value
wsOTA.Cells(i, 16).Value = wsBS.Cells(z, 26).Value
neui = i + 1
Exit
Do
End
If
i = i + 1
Loop
i = neui
z = z + 1
Loop