物料齐套VBA代码完善

wy820826

附件图片中的区域是用函数计算的，求高手帮完善VBA代码，谢谢！Sub test()    Dim dc As Object, arr, yrr, brr(), i
    Set dc = CreateObject("scripting.dictionary")
   arr = Sheet2.Range("A1").CurrentRegion
    yrr = Range("b2:G" & Range("b65536").End(3).Row)
    ReDim brr(1 To UBound(yrr), 1 To 2)
    For i = 1 To UBound(arr)
        dc(arr(i, 1)) = dc(arr(i, 1)) + arr(i, 4)
    Next
    For i = 1 To UBound(yrr)
        If dc.exists(yrr(i, 1)) Then brr(i, 1) = dc(yrr(i, 1)): dc(yrr(i, 1)) = dc(yrr(i, 1)) - yrr(i, 6): brr(i, 2) = dc(yrr(i, 1))
    Next
   [F2].Resize(UBound(yrr), 1) = brr
End Sub

wy820826

有没有大神路过

东升博胜纸箱

我也想了解解决方法