|
发表于 2021-11-30 21:02
|
显示全部楼层
本楼为最佳答案
- Sub 数据转移()
- Dim startrow As Integer, endrow As Integer
- Dim lastrow As Integer, i As Integer, j As Integer, k As Integer
- lastrow = Sheets(2).Range("a65536").End(xlUp).Row
- If lastrow = 1 Then Exit Sub
- k = 2
- Sheets(3).Range("a2:c999").Clear
- With Sheets(1)
- For i = 2 To lastrow
- startrow = Application.Match(Sheets(2).Range("a" & i), .Range("b1:b65536"), 0)
- j = startrow + 1
- Do Until .Range("b" & j) <> "" Or .Range("c" & j) = ""
- j = j + 1
- Loop
- endrow = j - 1
- .Range("b" & startrow & ":d" & endrow).Copy
- Sheets(3).Activate
- Range("a" & k).Select
- ActiveSheet.Paste
- k = k + endrow - startrow + 1
- Next
- End With
- End Sub
复制代码
|
|