Improper refference.

H

harbir

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, thi
sum was calculated using a formula(SUM).
Now I want to bring this sum, figure from sheet1 to sheet3, if I cop
the sum cell in sheet1, the formula is getting copied, which is no
able to make a proper reference.
I need to the way by which I can refer to a particular cell in sheet
from sheet3.
Any sort of help will be appreciated.
Than
 
B

Bernard Liengme

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
 
J

JE McGimpsey

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.
 
Top