本帖最后由 zjdh 于 2012-10-30 08:07 编辑
Sub 得到数据()
Dim I%, J%
Range(Range("Q2"), Cells(Range("o65536").End(3).Row, "ad")).ClearContents
For J = 2 To Range("o65536").End(3).Row
For I = 2 To Range("a65536").End(3).Row
If Cells(I, 1) = Cells(J, 15) Then
Range(Cells(J, "q"), Cells(J, "ad")).Value = Range(Cells(I, "a"), Cells(I, "n")).Value
Exit For
End If
Next
Next
End Sub