|
本帖最后由 lichuanboy44 于 2016-4-8 16:08 编辑
vba代码,调试好像成功了。- Sub try()
- Dim br()
- n = Range("F65536").End(3).Row
- arr = Range("B2:F" & n)
- ReDim br(1 To n - 1, 1 To 1)
- For i = 1 To n - 1
- a = arr(i, 1): b = arr(i, 3): c = arr(i, 5)
- If a Like "·*" Then
- If i > 1 Then
- br(p, 1) = Mid(ss, 2, Len(ss) - 1)
- ss = "": s上 = ""
- End If
- p = i
- End If
- If b <> "" Then
- br(i, 1) = b
- ss = ss & "、" & b
- s上 = b
- ElseIf b = "" And c <> "" Then
- br(i, 1) = s上
- End If
- Next
- [J2].Resize(n - 1, 1) = br
- End Sub
复制代码 |
|