software

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: www.excelforum.com/member.php...oamp;userid=29746
View this thread: www.excelforum.com/showthread...hreadid=497645
In cell G13 of Sheet 2 put this formula

=Sheet1!E26

Vaya con Dios,
Chuck, CABGx3
quot;Rozquot; wrote:

gt;
gt; I have two sheets in my book. I would like the amount that is in E26 in
gt; sheet 1 to automatically pull up in G13 of sheet 2. Can I put in a
gt; formula to do that? Thanks.
gt;
gt;
gt; --
gt; Roz
gt; ------------------------------------------------------------------------
gt; Roz's Profile: www.excelforum.com/member.php...oamp;userid=29746
gt; View this thread: www.excelforum.com/showthread...hreadid=497645
gt;
gt;

=if('sheet 1'!e26=quot;quot;,quot;quot;,'sheet 1'!e26)

in G13 of sheet 2.
Roz wrote:
gt;
gt; I have two sheets in my book. I would like the amount that is in E26 in
gt; sheet 1 to automatically pull up in G13 of sheet 2. Can I put in a
gt; formula to do that? Thanks.
gt;
gt; --
gt; Roz
gt; ------------------------------------------------------------------------
gt; Roz's Profile: www.excelforum.com/member.php...oamp;userid=29746
gt; View this thread: www.excelforum.com/showthread...hreadid=497645

--

Dave Peterson