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

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.


--
Roz
------------------------------------------------------------------------
Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746
View this thread: http://www.excelforum.com/showthread...hreadid=497636

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

In G13 of sheet two, enter:

=Sheet1!E26

HTH,
Paul

"Roz" wrote in message
...

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.


--
Roz
------------------------------------------------------------------------
Roz's Profile:
http://www.excelforum.com/member.php...o&userid=29746
View this thread: http://www.excelforum.com/showthread...hreadid=497636

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

In cell G13 of Sheet 2 put this formula

=Sheet1!E26

Vaya con Dios,
Chuck, CABGx3



"Roz" wrote:


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.


--
Roz
------------------------------------------------------------------------
Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746
View this thread: http://www.excelforum.com/showthread...hreadid=497636

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

Cool beans, Thanks a bunch!!


--
Roz
------------------------------------------------------------------------
Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746
View this thread: http://www.excelforum.com/showthread...hreadid=497636