搞定
Dim r As Row
Static s As String
Dim s1 As String
Dim n As Double
For i As Integer = 0 To Tables("表A").Rows.Count(True) - 1
r = Tables("表A").Rows(i,True)
If r.IsGroup
s1 = r("汇总").Split(" ")(0) & " " & r("汇总").Split(" ")(1)
r("型号") = r("汇总")
If s = "" OrElse s1 <> s Then
n = r("入仓") - R("出仓")
r("库存") = n
Else
n + = r("入仓") - R("出仓")
r("库存") = n
End If
s = s1
End If
Next