Hello all..
I am new here with a little VB coding experience! I am trying to calculate the values in column 3 by multiplying the each value in column 1 with the first value in cell 1 in column 2, and then do the same multiplying the each value in column 1 by the second value in cell 2 in column 2,and then add them up in each row for column 3.The # of rows in column 1 may not be the same as # of rows in column 2,any help would be appreciated! thanks a lots!
I've added an example (image) to the question thanks a lot in advance for your help!
Please note that I do not need to have those three columns ( I, II, III) just put them in there to show the steps. Thanks a lot!
I am new here with a little VB coding experience! I am trying to calculate the values in column 3 by multiplying the each value in column 1 with the first value in cell 1 in column 2, and then do the same multiplying the each value in column 1 by the second value in cell 2 in column 2,and then add them up in each row for column 3.The # of rows in column 1 may not be the same as # of rows in column 2,any help would be appreciated! thanks a lots!
I've added an example (image) to the question thanks a lot in advance for your help!
Please note that I do not need to have those three columns ( I, II, III) just put them in there to show the steps. Thanks a lot!