I've been having troubles with this a while. It's got me so annoyed tha
I've searched the Internet for some macros or some postings to m
problem. I haven't found anything and just to get over this, I'v
decided to post a message, maybe somebody can help me solve this....

I have 2 columns with f.e. 1000 rows of numbers - column A and Colum
B
in column A there are numbers f.e. from 1 to 1000. In column B ther
are numbers 0.5 0.7 4.5 6.7 12.4 2.8 4 5 etc....u
to 1000 different numbers. I would like to create column C, a third on
where there would be a result of these two rows in columns function f.e
multiply. If I want to multiply column A and B in row 1, so thei
product is in column C and repeat this process for all rows up to 1000
what should I do if I don't want to input manually function into colum
C =PRODUCT (A1,B1) , =PRODUCT (A2,B2), =PRODUCT (A3,B3) etc.... fo
all 1000 rows?

is there any way to automate this? same thing for summing up. ca
anybody help me please. thanks!!

--
rusca
-----------------------------------------------------------------------
ruscak's Profile: http://www.excelforum.com/member.php...fo&userid=2651
View this thread: http://www.excelforum.com/showthread.php?threadid=39781