Improper refference.

Hello!
I am new to microsoft excel and I want a help on the following matter.

I have data i.e. the sum of some figures in one cell on sheet1, this sum was calculated using a formula(SUM).
Now I want to bring this sum, figure from sheet1 to sheet3, if I copy the sum cell in sheet1, the formula is getting copied, which is not able to make a proper reference.
I need to the way by which I can refer to a particular cell in sheet1 from sheet3.
Any sort of help will be appreciated.
Thanx

To refer to cell A1 of Sheet3 in another sheet use =Sheet3!A1
If the sheetname has spaces in it, you need single quotes: ='Jan Sales'!A1
The easiest way to make these references is:
type =, open Sheet3; click on cell A1; press Enter
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"harbir" <[email protected]> wrote in
message news:[email protected]...
>
> Hello!
> I am new to microsoft excel and I want a help on the following matter.
>
> I have data i.e. the sum of some figures in one cell on sheet1, this
> sum was calculated using a formula(SUM).
> Now I want to bring this sum, figure from sheet1 to sheet3, if I copy
> the sum cell in sheet1, the formula is getting copied, which is not
> able to make a proper reference.
> I need to the way by which I can refer to a particular cell in sheet1
> from sheet3.
> Any sort of help will be appreciated.
> Thanx
>
>
> --
> harbir
> ------------------------------------------------------------------------
> harbir's Profile:
> http://www.excelforum.com/member.php...o&userid=32979
> View this thread: http://www.excelforum.com/showthread...hreadid=528062
>

If the SUM() is in sheet1, cell J10, say, then in sheet 3:

A1: =Sheet1!J10

It's easy to do this by typing

=

in the target cell, then navigating to the cell you want to copy and
selecting it. Hit enter to complete the formula.

In article <[email protected]>,
harbir <[email protected]> wrote:

> Hello!
> I am new to microsoft excel and I want a help on the following matter.
>
> I have data i.e. the sum of some figures in one cell on sheet1, this
> sum was calculated using a formula(SUM).
> Now I want to bring this sum, figure from sheet1 to sheet3, if I copy
> the sum cell in sheet1, the formula is getting copied, which is not
> able to make a proper reference.
> I need to the way by which I can refer to a particular cell in sheet1
> from sheet3.
> Any sort of help will be appreciated.
> Thanx