|
- Sub Macro2()
- Dim arr, brr, crr, i&, j%, d
- Set d = CreateObject("scripting.dictionary")
- arr = Range("a2:b" & Range("a65536").End(xlUp).Row)
- ReDim brr(1 To UBound(arr), 1 To 3)
- For j = 1 To 2
- crr = Sheets(j).UsedRange
- For i = 1 To UBound(crr)
- If crr(i, 1) = "名称:" Then Exit For
- If crr(i, 1) Like "名称:*" Then
- zf = Trim(Mid(crr(i, 1), 4))
- d(zf) = d(zf) + crr(i, 6)
- End If
- Next
- Next
- For i = 1 To UBound(arr)
- brr(i, 1) = d(arr(i, 1))
- brr(i, 3) = arr(i, 2) - brr(i, 1)
- brr(i, 2) = IIf(brr(i, 3) = 0, "OK", "NG")
- Next
- Range("c2").Resize(UBound(brr), 3) = brr
- End Sub
复制代码 |
|