calculating using 3 worksheets in a file
 

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


--
mark1124
------------------------------------------------------------------------
mark1124's Profile: http://www.excelforum.com/member.php...o&userid=26400
View this thread: http://www.excelforum.com/showthread...hreadid=396775

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.


--
saybut
------------------------------------------------------------------------
saybut's Profile: http://www.excelforum.com/member.php...fo&userid=5949
View this thread: http://www.excelforum.com/showthread...hreadid=396775