|
計算列位置及方式不盡相同????
Sub TEST()
Dim xR As Range, T$, S, xSum, C%, K%
For Each xR In Range([A1], [A65536].End(3))
If InStr("/型材成本/五金成本/玻璃成本/其它费用/", xR) Then T = xR: C = 0: K = 1: GoTo 101
If K = 1 Then K = 2: GoTo 101
If Right(xR, 3) = "合计:" And C > 0 Then xR(1, C) = xSum: xSum = 0: C = 0: K = 0: GoTo 101
Select Case T
Case "型材成本"
S = Val(xR(1, 7)) * Val(xR(1, 11)) * Val(xR(1, 16)) / 1000
xR(1, 22) = S: xSum = xSum + S: C = 22
Case "五金成本"
S = Val(xR(1, 13)) * Val(xR(1, 17))
xR(1, 22) = S: xSum = xSum + S: C = 22
Case "玻璃成本"
S = Val(xR(1, 15)) * Val(xR(1, 18))
xR(1, 23) = S: xSum = xSum + S: C = 23
Case "其它费用"
S = Val(xR(1, 6)) + Val(xR(1, 21))
xSum = xSum + S: C = 6
End Select
101: Next
End Sub
|
|