| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying formulas from one file to another
I have a master worksheet that pulls data from other worksheets in the
workbook. I want to copy those formulas to other workbooks which have different text in them so I can't just make copies of the original file. However, I don't want the target workbooks to refer back to the original file, only to the same worksheets within each workbook that the original workbook referred to. How do I do that? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copying formulas from one file to another
One method.
Select cells. EditReplace What: = With: ^^^^ Replace all. Now make the copy to the new workbook. Reverse the EditReplace process. Gord Dibben MS Excel MVP On Tue, 1 Aug 2006 15:01:02 -0700, Loris wrote: I have a master worksheet that pulls data from other worksheets in the workbook. I want to copy those formulas to other workbooks which have different text in them so I can't just make copies of the original file. However, I don't want the target workbooks to refer back to the original file, only to the same worksheets within each workbook that the original workbook referred to. How do I do that? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copying formulas from one file to another
Beautiful! Thank You.
"Gord Dibben" wrote: One method. Select cells. EditReplace What: = With: ^^^^ Replace all. Now make the copy to the new workbook. Reverse the EditReplace process. Gord Dibben MS Excel MVP On Tue, 1 Aug 2006 15:01:02 -0700, Loris wrote: I have a master worksheet that pulls data from other worksheets in the workbook. I want to copy those formulas to other workbooks which have different text in them so I can't just make copies of the original file. However, I don't want the target workbooks to refer back to the original file, only to the same worksheets within each workbook that the original workbook referred to. How do I do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying & Filling in data from One file into another. | Excel Worksheet Functions | |||
| File A and File B Together | Excel Discussion (Misc queries) | |||
| copying data from an unopened file programmatically | Excel Discussion (Misc queries) | |||
| Some formulas need file refresh in same worksheet | Excel Worksheet Functions | |||
| excel 2002 - copying formulas to another worksheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
