PDA

View Full Version : [SOLVED] Summing Macro



Pete
06-09-2008, 11:44 PM
Hi

Need a macro that will sum the individual values in worksheet "Modelling Volume" - see yellow highlighted

That relate to Other_Markerts_EU..... and post the results in Volume Summary in column F 60.

So the resulting sum for period 1Q09 is add to the corresponding column
in worksheet "Volume Summary".....and so on for the ente period.

Also need to take into account if other supply/demand customers are added or removed from the Modelling (Vol) the summing should adjust.

Pete
06-10-2008, 12:35 AM
OK. i think i can find the solution to the answer by add a correct verision of

.Range(Cells(BaseCell.Row, 6), Cells(BaseCell.Row + Numrows - 1, 6)).Value = "SUMIF('Modelling (Vol)'!$C:$C,'Volume Summary'!$B60,'Modelling (Vol)'!F:F)”

Add the formula across the row from F:BA....

Pete
06-10-2008, 01:22 AM
Please kindly ignore this question