加了一个辅助E列,
Sub aa()
Dim arr(1 To 4)
arr(4) = Range("a1").End(xlDown).Row
For i = 1 To 3
arr(i) = Application.Match(Sheet1.Range("e" & i), Sheet1.Range("a:a"), 0)
Next
For i = 1 To 3
Sheet1.Range("a" & arr(i) & ":a" & arr(i + 1) - 1).Copy Sheet1.Range("a" & arr(i)).Offset(0, i + 1)
Next
End Sub