calculating using 3 worksheets in a file

[mark1124]

I have and Excel file which 3 work sheets, in the first work sheet, i have the data in a range of cells, in the second work sheet i have another set of data in the same range of cells as that was in the first work sheet. I would like to add or multiply the value in the frist sheet with value in the second sheet using the same set of ranges, the output of this calculations, i would like to display in the third sheet in the same cell ranges as worksheet1 and worksheet2.

Please let me know how i could do this.

MARK1123

[saybut]

If your data starts from A1 in the first sheet and starts from A1 in the second sheet: On sheet 3 just type = then select the first cell in sheet 1, type * then select the first cell in sheet 2 and press return.

you can copy the formula down.