Sub ruqi() Dim count As Integer count = 2 Set xl = ActiveSheet Dim i As Integer Dim j As Integer
j = 3 While xl.Cells(count, 1) <> "" While xl.Cells(1, j) <> "" If xl.Cells(1, j) = xl.Cells(count, 1) Then For i = 2 To 2000 '改为你的行数 If xl.Cells(i, j) <> "" Then xl.Cells(count, 2) = xl.Cells(i, j) GoTo 1
End If Next End If j = j + 1 Wend 1 count = count + 1 Wend