- Sub tt()
- arr = [a1].CurrentRegion
- ReDim brr(1 To 100, 1 To 5)
- For j = 1 To UBound(arr, 2)
- If arr(1, j) = "乙" Then
- For i = 3 To UBound(arr)
- If Len(arr(i, j)) > 0 Then
- n = n + 1
- brr(n, 1) = arr(2, j)
- brr(n, 2) = arr(i, 1)
- brr(n, 3) = arr(i, 2)
- brr(n, 4) = arr(i, 3)
- brr(n, 5) = arr(i, j)
- End If
- Next
- End If
- Next
- [a15].Resize(1, 5) = Array("日期", "名称1", "名称2", "名称3", "内容")
- [a16].Resize(n, 5) = brr
- End Sub
复制代码 |