在Book1.xls中写如下代码: Sub Test() Dim i As Integer Workbooks.Open "D:\book2.xls", False, True For i = 1 To Range("A65000").End(xlUp).Row If Cells(i, 1) = ThisWorkbook.Sheets(1).Range("A1") Then ThisWorkbook.Sheets(1).Range("B1") = Cells(i, 2) ThisWorkbook.Sheets(1).Range("C1") = Cells(i, 3) End If Next i Workbooks("Book2.xls").Close 0 End Sub 运行它就可以了。本回答被网友采纳