multiplication macro
 

multiplication macro
hi there

in sheet 1 , in column c starting from c1 , i have lots of data going
downwards...

in sheet 2 i have a matrix starting from cella1 ,

number of rows in sheet 1 and 2 are same....

i want to be able to multiply cellc1 ( from sheet1 ) with sum of
columnA ( in sheet 2 , and then c2 with sum of column b , and then c3
with sum of column C and so on ...

i want to see all this sheet 3 , cell f5 onwards....


how do i do this using a mcro ?

can some one plsssss help ?

multiplication macro
 

Sam,

In cell F5 of sheet3, use the formula

=Sheet1!C1*SUM(INDIRECT("Sheet2!"&ADDRESS(1,ROW()-4)&":"&ADDRESS(65536,ROW()-4)))

and copy down for as many rows as your need.

If you want to copy accross, that's a different formula.

HTH,
Bernie
Excel MVP


"Sam" wrote in message om...
multiplication macro
hi there

in sheet 1 , in column c starting from c1 , i have lots of data going
downwards...

in sheet 2 i have a matrix starting from cella1 ,

number of rows in sheet 1 and 2 are same....

i want to be able to multiply cellc1 ( from sheet1 ) with sum of
columnA ( in sheet 2 , and then c2 with sum of column b , and then c3
with sum of column C and so on ...

i want to see all this sheet 3 , cell f5 onwards....


how do i do this using a mcro ?

can some one plsssss help ?

multiplication macro
 

Sam,

Here's the formula for Sheet3 cell F5 if you want to copy across.

=INDIRECT("Sheet1!C" & COLUMN()-5)*SUM(Sheet2!A:A)

HTH,
Bernie
Excel MVP


"Sam" wrote in message om...
multiplication macro
hi there

in sheet 1 , in column c starting from c1 , i have lots of data going
downwards...

in sheet 2 i have a matrix starting from cella1 ,

number of rows in sheet 1 and 2 are same....

i want to be able to multiply cellc1 ( from sheet1 ) with sum of
columnA ( in sheet 2 , and then c2 with sum of column b , and then c3
with sum of column C and so on ...

i want to see all this sheet 3 , cell f5 onwards....


how do i do this using a mcro ?

can some one plsssss help ?