View Single Post
  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

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