|
看一下是不是你想要的- Sub tst()
- arr = [f1].CurrentRegion
- brr = [a1].CurrentRegion
- Set d = CreateObject("scripting.dictionary")
- Dim crr()
- For i = 2 To UBound(arr)
- Kwds = arr(i, 1)
- For j = 2 To UBound(brr)
- If InStr(brr(j, 4), Kwds) > 0 Then
- d(Kwds) = d(Kwds) & brr(j, 3) & " "
- End If
- Next j
- n = Application.Ceiling((UBound(Split(Trim(d(Kwds)), " ")) + 1) / 76, 1)
- ReDim crr(1 To 76, 1 To n): drr = Split(Trim(d(Kwds)), " ")
- For k = 0 To UBound(drr)
- If k <= 75 Then
- crr(k + 1, 1) = drr(k)
- Else
- crr(k - 75, 2) = drr(k)
- End If
- Next
- icol = Sheets("过渡表").[a1].End(2).Column + 1
- Sheets("过渡表").Cells(1, icol).Resize(76, n) = crr
- Next i
- End Sub
复制代码
|
|