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

 

[Guest]

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

 

[Dave Peterson]

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

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

 

[Guest]

Copy ->Paste Special -> Values

This copies only the value of the cell.

 

[ArenaNinja]

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