View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TOMB TOMB is offline
external usenet poster
 
Posts: 25
Default Copy/Paste Formulas Without Linking Books

How do I copy formulas which read from several sheets within a workbook into
another workbook? Currently, as I copy from one book to another, Excel wants
to link the two books. The books have identical sheet names/page design.

Example:
Copy from:
MyFile.xls cell A1 formula
=Jan!C5+Feb!C5+Mar!C5+Apr!C5

Paste to:
Newfile.xls Cell A1 becomes
='[MyFile.xls]Jan'!C5+'[MyFile.xls]Feb'!C5+'[MyFile.xls]Mar'!C5+'[MyFile.xls]Apr'!C5

Can I copy without linking?

Thanks in advance!