|
应该是满足三个条件- Sub Macro1()
- Dim arr, brr, crr, d, i&, j%, zf$
- Set d = CreateObject("scripting.dictionary")
- Sheet1.Activate
- arr = Range("a3").CurrentRegion
- brr = Sheet2.Range("a1").CurrentRegion
- ReDim crr(1 To UBound(arr) - 2, 1 To UBound(arr, 2) - 2)
- For i = 2 To UBound(brr)
- zf = brr(i, 1) & "," & brr(i, 2) & "," & brr(i, 3)
- d(zf) = brr(i, 4)
- Next
- For i = 3 To UBound(arr)
- For j = 3 To UBound(arr, 2)
- zf = arr(1, j) & "," & arr(2, j) & "," & arr(i, 2)
- crr(i - 2, j - 2) = d(zf)
- Next
- Next
- Range("c3").Resize(UBound(crr), UBound(crr, 2)) = crr
- End Sub
复制代码 |
评分
-
查看全部评分
|