| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy formulas to another workbook
One method is to select all the formulas in the sheet in the source workbook.
EditReplace What: = With: ^^^ Replace all. Now copy to the new sheet in target workbook. Reverse the process in new sheet and source sheet or just close the source workbook without saving changes. Gord Dibben MS Excel MVP On Wed, 21 Nov 2007 13:41:01 -0800, karmela wrote: Hi, is there any possibility to copy formulas from one workbook/worksheet to another and prevent from reference to the old workbook/worksheet? In this time I must go cell to cell and delete the old name.... Thanks for help to spare time karmela |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I copy a worksheet with formulas to another workbook? | Excel Worksheet Functions | |||
| protect my excel workbook so no one can see or copy my formulas? | Excel Discussion (Misc queries) | |||
| How to copy worksheet or workbook without formulas | Excel Discussion (Misc queries) | |||
| How do you copy a sheet (with Formulas) to another Workbook? | Excel Discussion (Misc queries) | |||
| How to copy formulas from one workbook to another | Excel Discussion (Misc queries) | |||
Hybrid Mode
