|
- Sub 提取全部()
- Dim arr, brr, crr, d, i&, j%
- Set d = CreateObject("scripting.dictionary")
- arr = Range("a1").CurrentRegion
- ReDim brr(1 To UBound(arr) - 2, 1 To UBound(arr, 2) - 2)
- crr = Sheet2.Range("a1").CurrentRegion
- For i = 3 To UBound(crr)
- For j = 3 To UBound(crr, 2)
- zf = crr(i, 1) & "," & crr(2, j)
- d(zf) = crr(i, j)
- Next
- Next
- For i = 3 To UBound(arr)
- For j = 3 To UBound(arr, 2)
- zf = arr(i, 1) & "," & arr(2, j)
- brr(i - 2, j - 2) = d(zf)
- Next
- Next
- Range("c3").Resize(UBound(brr), UBound(brr, 2)) = brr
- End Sub
复制代码 |
|