本帖最后由 风化石 于 2012-11-14 09:11 编辑
Sub Macro1()
Application.ScreenUpdating = False '禁用刷新
With Sheets("资料表")
x = .Range("R65536").End(xlUp).Row
y = Range("F65536").End(xlUp).Row
For i = 2 To y
If IsNumeric(Application.Match(Cells(i, 6), .Range("R1:R" & x), 0)) Then
m = Application.Match(Cells(i, 6), .Range("R1:R" & x), 0) ' 行数
.Range("N" & m & ":Q" & m).Copy Cells(i, 1)
.Range("E" & m).Copy Cells(i, 5)
End If
Next
End With
End Sub
按条件填入数据.rar
(12.37 KB, 下载次数: 32)