software

I need to transpose some information from a workbook to a new workbook,
which will contain summaries of many different notebooks. How do I copy
the CONTENTS of all cells in a workbook, without taking the formulas?
(i.e.: if R28 is quot;=SUM(R4:R27)quot; and the result is 512, I want Excel to
post 512, NOT the formula.--
ArenaNinja
------------------------------------------------------------------------
ArenaNinja's Profile: www.excelforum.com/member.php...oamp;userid=33624
View this thread: www.excelforum.com/showthread...hreadid=543114
Try

copy , paste special, values

SS--
simonsmith
------------------------------------------------------------------------
simonsmith's Profile: www.excelforum.com/member.php...oamp;userid=34235
View this thread: www.excelforum.com/showthread...hreadid=543114Select the cells that you want to copy and pull-down:

Edit gt; Copy

Go to the worksheet you want to fill and pull-down:

Edit gt; Paste Special... gt; and check the values button
--
Gary's Studentquot;ArenaNinjaquot; wrote:

gt;
gt; I need to transpose some information from a workbook to a new workbook,
gt; which will contain summaries of many different notebooks. How do I copy
gt; the CONTENTS of all cells in a workbook, without taking the formulas?
gt; (i.e.: if R28 is quot;=SUM(R4:R27)quot; and the result is 512, I want Excel to
gt; post 512, NOT the formula.
gt;
gt;
gt; --
gt; ArenaNinja
gt; ------------------------------------------------------------------------
gt; ArenaNinja's Profile: www.excelforum.com/member.php...oamp;userid=33624
gt; View this thread: www.excelforum.com/showthread...hreadid=543114
gt;
gt;

Edit|Copy the range
select the new location
edit|paste special|values

(and maybe edit|paste special|formats???)

ArenaNinja wrote:
gt;
gt; I need to transpose some information from a workbook to a new workbook,
gt; which will contain summaries of many different notebooks. How do I copy
gt; the CONTENTS of all cells in a workbook, without taking the formulas?
gt; (i.e.: if R28 is quot;=SUM(R4:R27)quot; and the result is 512, I want Excel to
gt; post 512, NOT the formula.
gt;
gt; --
gt; ArenaNinja
gt; ------------------------------------------------------------------------
gt; ArenaNinja's Profile: www.excelforum.com/member.php...oamp;userid=33624
gt; View this thread: www.excelforum.com/showthread...hreadid=543114

--

Dave Peterson

Copy -gt;Paste Special -gt; Values

This copies only the value of the cell.

quot;ArenaNinjaquot; wrote:

gt;
gt; I need to transpose some information from a workbook to a new workbook,
gt; which will contain summaries of many different notebooks. How do I copy
gt; the CONTENTS of all cells in a workbook, without taking the formulas?
gt; (i.e.: if R28 is quot;=SUM(R4:R27)quot; and the result is 512, I want Excel to
gt; post 512, NOT the formula.
gt;
gt;
gt; --
gt; ArenaNinja
gt; ------------------------------------------------------------------------
gt; ArenaNinja's Profile: www.excelforum.com/member.php...oamp;userid=33624
gt; View this thread: www.excelforum.com/showthread...hreadid=543114
gt;
gt;


TY... the obvious stuff always gets the best of me --
ArenaNinja
------------------------------------------------------------------------
ArenaNinja's Profile: www.excelforum.com/member.php...oamp;userid=33624
View this thread: www.excelforum.com/showthread...hreadid=543114