Tom,

Just copy the formula to the other cells in the column. Enter the formula in
the first row of your calculations. Then highlight the cells that you want
to contain the formula, starting with the one that has the formula. Then
press control-D and the formula will get copied and adjusted automatically
for the row change. Hope this is what you were asking.


-----Original Message-----
Need to multiply one column by another and show product in the next column.
Know the formula for one row (=B2*C2) but can't figure out how to multiply
each row in column B by each row in column. For now I am entering the
formula in each row but there has to be an easier way.

        The NOSPIN Group has added a new feature on our website,
           web based bulletinboard for questions and answers:
              Visit our sister website at http://nospin.com