Macro which adds columns in different worksheets

[discodave]

hi

im struggling to make a macro which,
adds all the values in one column on a worksheet called 'place order', to the values in a column in a different worksheet called 'sales'
(hope that makes sense)

if anyone could help me out, id be really appreciated
thanks

 

[texasalynn]

so are you wanting to take the sum of the column in "Place Order" (1 total), to be added to the total in the other sheet "Sales" (1 total)??

Or are you taking individual lines in the column to be added to individual lines in the other?

 

[discodave]

no not the sum, each individual line to be added to an individual line in another column in the other worksheet