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 ?