|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Sub javba()
Dim i%, j, k, d, arr, brr
Set d = CreateObject("scripting.dictionary")
brr = Sheets("4").Range("a1:l" & Sheets("4").Cells(Rows.Count, "b").End(xlUp).Row)
For i = 1 To Sheets.Count
arr = Sheets(i).Range("a1:l" & Sheets(i).Cells(Rows.Count, "b").End(xlUp).Row)
If Sheets(i).Name <> "4" Then
For j = 2 To UBound(arr)
d(arr(j, 2)) = Array(arr(j, 3), arr(j, 4), arr(j, 5), arr(j, 6), arr(j, 7), arr(j, 8), arr(j, 9), arr(j, 10), arr(j, 11), arr(j, 12))
Next
End If
Next
For k = 2 To UBound(brr)
Sheets("4").Cells(k, 2).Offset(0, 1).Resize(1, UBound(d(brr(k, 2))) + 1) = d(brr(k, 2))
Next
End Sub
|
|