Lou
In C1 on sheet1 you have =A1+B1
In any cell on sheet2 you enter =sheet1!C1
Or go to a cell on sheet2 and type an = sign, then swithch to sheet1.
Select C1 and hit the <ENTER key.
Or copy sheet1 C1 and switch to sheet2.
Select a cell then Paste SpecialPaste Link
Gord Dibben Excel MVP
On Sun, 28 Nov 2004 15:31:02 -0800, Lou wrote:
I am trying to diplay the answer from a fomula on one page to another so that
i don't have to have the same formula twice..i keep getting an
error....Please help...Lou
|