Excel - HELP

[rlculver]

Hi,

I have created a formula which calculates a number of cells together. The results of these are held in A10.

Is their a way, I can copy the results of the formula to Sheet 3 ?

What command do I need to use to achieve this. Also if they change any data in the calculation, it needs to automatically update the various data including the data held in Sheet 3.

Any ideas. I am using Excel 2007. Thanks

 

[Da[]San]

Have you not just tried typing in = (go into book 1) a10 in sheet 3

 

[fretted]

Have you not just tried typing in = (go into book 1) a10 in sheet 3

which will give you the formula =Sheet1!a10