Copying CONTENTS not Formulas

[ArenaNinja]

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 "=SUM(R4:R27)" and the result is 512, I want Excel to post 512, NOT the formula.

[simonsmith]

Try

copy , paste special, values

SS

[ArenaNinja]

TY... the obvious stuff always gets the best of me

[Gary''s Student]

Select the cells that you want to copy and pull-down:

Edit > Copy

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

Edit > Paste Special... > and check the values button
--
Gary's Student


"ArenaNinja" wrote:

>
> 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 "=SUM(R4:R27)" and the result is 512, I want Excel to
> post 512, NOT the formula.
>
>
> --
> ArenaNinja
> ------------------------------------------------------------------------
> ArenaNinja's Profile: http://www.excelforum.com/member.php...o&userid=33624
> View this thread: http://www.excelforum.com/showthread...hreadid=543114
>
>

[James Hamilton]

Copy ->Paste Special -> Values

This copies only the value of the cell.

"ArenaNinja" wrote:

>
> 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 "=SUM(R4:R27)" and the result is 512, I want Excel to
> post 512, NOT the formula.
>
>
> --
> ArenaNinja
> ------------------------------------------------------------------------
> ArenaNinja's Profile: http://www.excelforum.com/member.php...o&userid=33624
> View this thread: http://www.excelforum.com/showthread...hreadid=543114
>
>

[Dave Peterson]

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

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

ArenaNinja wrote:
>
> 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 "=SUM(R4:R27)" and the result is 512, I want Excel to
> post 512, NOT the formula.
>
> --
> ArenaNinja
> ------------------------------------------------------------------------
> ArenaNinja's Profile: http://www.excelforum.com/member.php...o&userid=33624
> View this thread: http://www.excelforum.com/showthread...hreadid=543114

--

Dave Peterson