EXCEL help

[Nesh]

Hey guys I need some help here on EXCEL and I really need some.

Here's what I need. I have 4 sheets in one excel document. 3 include data/numbers, and I want to use formulas on the fourth one that will use the data from the other sheets.

Does anyone know how can I do that??

 

[Captain Chickenpants]

Yes.
You can name the worksheet and refer to it.
So using the default worksheet naming convention to get the value of cell A2 in worksheet 2 you would use
=Sheet2!A2

Also you can name a cell with a constant name.
When you click on a cell you will see it's name (e.g. A2) in the box in the top left corner, simply click on the name and edit it. Or select Name from the Insert menu. You can then just refer to that name in formula.

CC

 

[Jabbah]

In sheet3 A1:
=Sheet1!A1-Sheet2!A1
and in in ranges:
=SUM(Sheet2!A1:Sheet2!C1)

 

[Simon F]

Does anyone know how can I do that??

Although the guys have answered this, you can just write your formula and then select the cells on the other pages and it will automatically put the full reference in.

 

[Nesh]

Thanks a lot ppl I truelly appreciate it