- Sub Macro1()
- Dim arr, brr(1 To 60000, 1 To 5)
- Dim i&, s&, j%, k%, k2%, gjc$$
- arr = Sheet1.Range("a1").CurrentRegion
- gjc = "词林" '关键词
- For i = 2 To UBound(arr)
- If arr(i, 5) = gjc Then
- x = Split(arr(i, 6))
- For j = 0 To UBound(x)
- If x(j) <> "" Then
- s = s + 1
- If j = 0 Then
- brr(s, 1) = arr(i, 1)
- brr(s, 2) = arr(i, 2)
- brr(s, 3) = arr(i, 5)
- End If
- brr(s, 5) = x(j)
- End If
- Next
- For k = 7 To UBound(arr, 2)
- If arr(i, k) <> "" Then s = s + 1: brr(s, 5) = arr(i, k)
- Next
- Else
- s = s + 1
- brr(s, 1) = arr(i, 1)
- brr(s, 2) = arr(i, 2)
- brr(s, 3) = arr(i, 5)
- brr(s, 5) = arr(i, 6)
- For k2 = 7 To UBound(arr, 2)
- If arr(i, k2) <> "" Then s = s + 1: brr(s, 5) = arr(i, k2)
- Next
- End If
- Next
- [a1:e1].Value = "标题"
- Range("a2").Resize(s, 5) = brr
- End Sub
复制代码 |