|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub test()
- Set d = CreateObject("scripting.dictionary")
- Set wb = Workbooks.Open(ThisWorkbook.Path & "\b.xlsx")
- With wb.Sheets("sheet1")
- arr = .[a1].CurrentRegion
- End With
- wb.Close False
- For i = 1 To UBound(arr)
- d(arr(i, 1)) = Array(arr(i, 2), arr(i, 3), arr(i, 4)) '假设有4列,当然可以根据需要乱序放入数组
- Next
- With Sheets("sheet1")
- arr = .Range("a1:d" & .Cells(Rows.Count, 1).End(3).Row)
- For i = 2 To UBound(arr)
- If d.exists(arr(i, 1)) Then
- t = d(arr(i, 1))
- For j = 0 To UBound(t)
- arr(i, j + 2) = t(j)
- Next
- End If
- Next
- .[a1].Resize(UBound(arr), 4) = arr
- End With
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|