software

I have a list of a bunch of prices which I total up by month at the
bottom of the worksheet.

What I want to do is instead of totally up the prices at the bottom, I
want to move the total to another worksheet and keep the original sheet
just for raw data.
But right now, all my formulas and math assumes the cells I am totally
are in the same sheed, if I move all that, it will not be looking at
the correct cells.
How can I tell the formula to get the value from another worksheet?--
mrjeffy321
------------------------------------------------------------------------
mrjeffy321's Profile: www.excelforum.com/member.php...oamp;userid=30618
View this thread: www.excelforum.com/showthread...hreadid=502726Hello,
Go to a Cell in the new sheet. type an = sign, do not click out of the cell,
use your mouse to click over to the work sheet with your totals, click in the
cell where your total is (in the details sheet), hit enter. The total on your
new work sheet will be equal to the total on your details tab.

quot;mrjeffy321quot; wrote:

gt;
gt; I have a list of a bunch of prices which I total up by month at the
gt; bottom of the worksheet.
gt;
gt; What I want to do is instead of totally up the prices at the bottom, I
gt; want to move the total to another worksheet and keep the original sheet
gt; just for raw data.
gt; But right now, all my formulas and math assumes the cells I am totally
gt; are in the same sheed, if I move all that, it will not be looking at
gt; the correct cells.
gt; How can I tell the formula to get the value from another worksheet?
gt;
gt;
gt; --
gt; mrjeffy321
gt; ------------------------------------------------------------------------
gt; mrjeffy321's Profile: www.excelforum.com/member.php...oamp;userid=30618
gt; View this thread: www.excelforum.com/showthread...hreadid=502726
gt;
gt;


Perfect-!-
It worked. Thanks--
mrjeffy321
------------------------------------------------------------------------
mrjeffy321's Profile: www.excelforum.com/member.php...oamp;userid=30618
View this thread: www.excelforum.com/showthread...hreadid=502726
Bump

Anyone know how to do this?--
mrjeffy321
------------------------------------------------------------------------
mrjeffy321's Profile: www.excelforum.com/member.php...oamp;userid=30618
View this thread: www.excelforum.com/showthread...hreadid=502726