| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro 4 copy & paste between 2 books/files | Excel Discussion (Misc queries) | |||
| How do I copy & paste formulas without them linking to the source | Excel Discussion (Misc queries) | |||
| Copy-Paste Special-linking problem | Excel Programming | |||
| Copy & Paste without the formulas | Excel Programming | |||
| Put copy/paste between books in macro | Excel Programming | |||
Threaded Mode
