|
发表于 2015-6-22 22:30
|
显示全部楼层
本楼为最佳答案
楼主测试:- Sub 提取数据()
- Dim arr, ar, i%, j%, brr(0, 2 To 11)
- arr = [a8].CurrentRegion
- For i = 2 To UBound(arr)
- For j = 2 To UBound(arr, 2)
- If arr(i, j) Then brr(0, j) = brr(0, j) & " " & arr(i, 1)
- Next
- Next
- [x8:ag200] = ""
- [x8:ag200].NumberFormatLocal = "@"
- For i = 2 To 11
- If brr(0, i) <> "" Then
- ar = Split(Mid(brr(0, i), 2))
- Cells(8, 22 + i).Resize(UBound(ar) + 1) = Application.Transpose(ar)
- End If
- Next
- End Sub
复制代码
请教数据的提取.rar
(21.71 KB, 下载次数: 24)
|
|