help....

[aliceting]

how do i calculate range of data in excel,and display it in another new worksheet.For exmaple,stock on hand is in range A1,and stock used is in range B1,and now,i need to display the balance stock at range C1 in the new worksheet,and copy all the data from range A1 and B1 also.how.?any example?

[SamS]

On 2002-05-04 01:32, aliceting wrote:
how do i calculate range of data in excel,and display it in another new worksheet.For exmaple,stock on hand is in range A1,and stock used is in range B1,and now,i need to display the balance stock at range C1 in the new worksheet,and copy all the data from range A1 and B1 also.how.?any example?

The formula in cell C1 is =A1-B1
in the second worksheet if you want it to reflect the original data of A1 for example you would use =Sheet1!A1 and so forth. You can do this by point and click eg in the second worksheet type = into the cell then go to the first worksheet click in the cell you want and press enter.
I may have misread your post, if so please excuse and repost.

[ This Message was edited by: SamS on 2002-05-04 14:48 ]