Using Data From Different Sheets Via Formula/ae
 

Is there a way I can use data from different sheets within a workbook via
formula?

Naeema

Using Data From Different Sheets Via Formula/ae
 

Yes. The general syntax is =Sheet2!A10+75 etc.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Naeema" wrote:

Is there a way I can use data from different sheets within a workbook via
formula?

Naeema

Using Data From Different Sheets Via Formula/ae
 

Yes.

Click in the cell where you want to create your formula, start with the =
sign and go on from there. When you get to the stage where you want to use
a reference to a cell on another sheet, just go to the other sheet and click
in the relevant cell. The formula will fill in the references accordingly,
so you'll end up with something like
=Sheet2!B2+Sheet2!B12-'Third sheet'!B3
--
David Biddulph

"Naeema" wrote in message
...
Is there a way I can use data from different sheets within a workbook via
formula?

Naeema