Pete
06-25-2008, 04:48 AM
Hi Experts
Need to subtract the following to formula so that Pricing Supply - Pricing Demand
here is the code snippet.
"=((" & _
"'Pricing Supply'!$F" & startrow + 1 & " * " & Chr(10) & _
"(Shipping UFC'!$F" & startrow + 1 & "))" & Chr(10) & _
"*" & Chr(10) & _
"'Modelling (Vol)'!$F" & startrow + 1 & ")" -
"=((" & _
"'Pricing Demand'!$F" & startrow + 1 & " * " & Chr(10) & _
"(1-'Shipping BOG'!$F" & startrow + 1 & "))" & Chr(10) & _
"*" & Chr(10) & _
"'Modelling (Vol)'!$F" & startrow + 1 & ")"
Need to subtract the following to formula so that Pricing Supply - Pricing Demand
here is the code snippet.
"=((" & _
"'Pricing Supply'!$F" & startrow + 1 & " * " & Chr(10) & _
"(Shipping UFC'!$F" & startrow + 1 & "))" & Chr(10) & _
"*" & Chr(10) & _
"'Modelling (Vol)'!$F" & startrow + 1 & ")" -
"=((" & _
"'Pricing Demand'!$F" & startrow + 1 & " * " & Chr(10) & _
"(1-'Shipping BOG'!$F" & startrow + 1 & "))" & Chr(10) & _
"*" & Chr(10) & _
"'Modelling (Vol)'!$F" & startrow + 1 & ")"