Copying CONTENTS not Formulas
 

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

Copying CONTENTS not Formulas
 

Try

copy , paste special, values

SS


--
simonsmith
------------------------------------------------------------------------
simonsmith's Profile: http://www.excelforum.com/member.php...o&userid=34235
View this thread: http://www.excelforum.com/showthread...hreadid=543114

Copying CONTENTS not Formulas
 

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

Copying CONTENTS not Formulas
 

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

Copying CONTENTS not Formulas
 

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

Copying CONTENTS not Formulas
 

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


--
ArenaNinja
------------------------------------------------------------------------
ArenaNinja's Profile: http://www.excelforum.com/member.php...o&userid=33624
View this thread: http://www.excelforum.com/showthread...hreadid=543114