Sub Macro2()
Application.ScreenUpdating = False '禁用刷新
x = Range("B65536").End(xlUp).Row '行数
For i = 4 To x
If IsNumeric(Application.Match(Cells(i, 2), Sheets("数据源").Range("B1:B3000"), 0)) Then
m = Application.Match(Cells(i, 2), Sheets("数据源").Range("B1:B3000"), 0)
Sheets("数据源").Range("E" & m & ":AN" & m).Copy
Range("E" & i).PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:=True
End If
Next
End Sub
Sub Macro2()
Application.ScreenUpdating = False '禁用刷新
x = Range("B65536").End(xlUp).Row '行数
For i = 4 To x
If IsNumeric(Application.Match(Cells(i, 2), Sheets("数据源").Range("B1:B3000"), 0)) Then
m = Application.Match(Cells(i, 2), Sheets("数据源").Range("B1:B3000"), 0)
Sheets("数据源").Range("E" & m & ":AN" & m).Copy
Range("E" & i).PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:=True
End If
Next
End Sub