Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Coping a formula
Hello -
I have a practice file in which I'm working out my formulas. When I copy to the 'real' file, the practice file name is in the formula. Will someone please tell me how to copy from one workbook to another without referencing the original workbook. Thanks to you all. Marc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Coping a formula
Copy the formula from the formula bar, not the cell.
Biff "Marc" wrote in message ... Hello - I have a practice file in which I'm working out my formulas. When I copy to the 'real' file, the practice file name is in the formula. Will someone please tell me how to copy from one workbook to another without referencing the original workbook. Thanks to you all. Marc |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Coping a formula
Marc
Couple of methods. 1. Right-click on the sheet and "move or copy" Checkmark "create a copy" to real file which is also open. Will not create links to source file. 2. EditReplace What: = With: ^^^ Replace all. Copy to target file then reverse the process in target file. Close the practice file without saving changes or reverse there also. Gord Dibben MS Excel MVP On Fri, 12 Jan 2007 18:34:01 -0800, Marc wrote: Hello - I have a practice file in which I'm working out my formulas. When I copy to the 'real' file, the practice file name is in the formula. Will someone please tell me how to copy from one workbook to another without referencing the original workbook. Thanks to you all. Marc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
formula coping 5 consecutive cell triggered by a value from anoth. | Excel Discussion (Misc queries) |