|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub gj23w98()
- Dim i, j, arr, d
- Set d = CreateObject("Scripting.Dictionary")
- arr = [g10:g15]
- brr = Range("a1:c" & [c65536].End(3).Row)
- For j = 1 To UBound(arr)
- For i = 1 To UBound(brr)
- If InStr(brr(i, 3), arr(j, 1)) Then
- d(arr(j, 1)) = d(arr(j, 1)) & brr(i, 1) & "," & brr(i, 2) & ","
- End If
- Next i, j
- k = 11
- For Each sj In d
- i = 2
- For j = 0 To UBound(Split(d(sj), ",")) - 1 Step 2
- Cells(i, k) = Split(d(sj), ",")(j)
- Cells(i, k + 1) = Split(d(sj), ",")(j + 1)
- i = i + 1
- Next j
- k = k + 2
- Next
- End Sub
复制代码 |
|