software

Worksheet A has a Budgeted Value of $100 and next to it I want a value
entered that tells me what I have left from what I have spent

The values of what I have spent are on Worksheet B

How do I make it to where one Worksheet talks to another? Basically

I want to take the total amount from what I spent in Worksheet B and
deduct it from by Budget in Worksheet A--
liftapia
------------------------------------------------------------------------
liftapia's Profile: www.excelforum.com/member.php...oamp;userid=33190
View this thread: www.excelforum.com/showthread...hreadid=530076liftapia,

Assuming that your total on Sheet A is in Cell C9, then put this in D9:

=C9-Sheet2!E20

where Sheet2 is the name of your Sheet B and E20 is the sum of what you have
already spent on that sheet. Make sure you keep the ! in there. Hope this
helps!

Mark

quot;liftapiaquot; wrote:

gt;
gt; Worksheet A has a Budgeted Value of $100 and next to it I want a value
gt; entered that tells me what I have left from what I have spent
gt;
gt; The values of what I have spent are on Worksheet B
gt;
gt; How do I make it to where one Worksheet talks to another? Basically
gt;
gt; I want to take the total amount from what I spent in Worksheet B and
gt; deduct it from by Budget in Worksheet A
gt;
gt;
gt; --
gt; liftapia
gt; ------------------------------------------------------------------------
gt; liftapia's Profile: www.excelforum.com/member.php...oamp;userid=33190
gt; View this thread: www.excelforum.com/showthread...hreadid=530076
gt;
gt;


Wonderful !! Thanx SO Much!--
liftapia
------------------------------------------------------------------------
liftapia's Profile: www.excelforum.com/member.php...oamp;userid=33190
View this thread: www.excelforum.com/showthread...hreadid=530076