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.