Cell in Sheet one automatically going to a cell in sheet two

[Roz]

Hey again...I have two sheets in my book. I would like the amount that
is in E26 in sheet 1 to automatically pull up in G13 of sheet 2. Can I
put in a formula to do that? Thanks.

 

[PCLIVE]

In G13 of sheet two, enter:

=Sheet1!E26

HTH,
Paul

 

[CLR]

In cell G13 of Sheet 2 put this formula

=Sheet1!E26

Vaya con Dios,
Chuck, CABGx3

 

[Roz]

Cool beans, Thanks a bunch!!