|
发表于 2015-10-28 14:15
|
显示全部楼层
本楼为最佳答案
- Sub grf()
- Dim arr, brr, i%
- Set d = CreateObject("scripting.dictionary")
- arr = Sheets("汇总表").[a1].CurrentRegion
- For i = 2 To UBound(arr)
- d(arr(i, 1)) = i
- Next
- brr = Sheets("子表").[a1].CurrentRegion
- For i = 2 To UBound(brr)
- If d(brr(i, 1)) > 0 Then arr(d(brr(i, 1)), 3) = brr(i, 3)
- Next
- With Sheets("结果")
- .UsedRange.Cells.ClearContents
- .[a1].Resize(UBound(arr), UBound(arr, 2)) = arr
- End With
- End Sub
复制代码 |
|