software

Hi there.. I have a report that i need to create.. I have a file that
has 5 worksheets and i need to add a cell from sheet one to a cell in
sheet 5... I'm sure this is simple but i cant figure out how to add
from multiple worksheets

thanks--
bustanutti21
------------------------------------------------------------------------
bustanutti21's Profile: www.excelforum.com/member.php...oamp;userid=25542
View this thread: www.excelforum.com/showthread...hreadid=495834Let XL make the formula for you.

Click in the cell that is to display the total, and enter an equal sign,
=
then, click in the cell containing the first value,
Then hit the plus sign

Now, click on the Sheet5 tab, and click in the cell containing the second
value,
And then hit lt;Entergt;.

You now have the syntax that you can duplicate for your other totals, or,
you can continue creating your formulas in the same manner that you did the
first one.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================quot;bustanutti21quot; gt;
wrote in message
news:bustanutti21.20icjy_1135366201.0555@excelforu m-nospam.com...
gt;
gt; Hi there.. I have a report that i need to create.. I have a file that
gt; has 5 worksheets and i need to add a cell from sheet one to a cell in
gt; sheet 5... I'm sure this is simple but i cant figure out how to add
gt; from multiple worksheets
gt;
gt; thanks
gt;
gt;
gt; --
gt; bustanutti21
gt; ------------------------------------------------------------------------
gt; bustanutti21's Profile:
www.excelforum.com/member.php...oamp;userid=25542
gt; View this thread: www.excelforum.com/showthread...hreadid=495834
gt;