7,762
社区成员
发帖
与我相关
我的任务
分享
Sub test()
''代码放在目标表格的vbe里
''首先对a~e列进行排序
Columns("A:E").Sort Key1:=Range("A1")
Dim iStart As Long, iEnd As String, i As Long
Dim j As Long, nR As Long, cR As Long, ww
ww = Split("p-,f-,m-,pe", ",")
nR = Range("a1").End(xlDown).Row ''最后一列所在的行
cR = 1
For i = 0 To UBound(ww)
iStart = 0
iEnd = 0
For j = 1 To nR
If LCase$(Left$(Cells(j, 1), 2)) = ww(i) Then
If iStart = 0 Then iStart = j
iEnd = j
End If
Next
''复制数据块
Range("a" & iStart & ":e" & iEnd).Copy Range("h" & cR)
cR = cR + iEnd - iStart + 1
Next
End Sub
......