Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Exact Formula
Hi,
I want to copy a range of formulae from one work book to another identicaly formatted workbook but i do not wish the formulae to link back into the old spreadsheet. Both workbooks, Book1 & Book2 have a Volumes sheet and a Check sheet and when i copy the formulae from Check on Book1 to Book 2, the fomulae still point to the Volumes sheet on Book1 instead of the one on the same book. What is the best way to do this? The closest i've come is by using the following formula: Sheets("New Check").Range("j4:p20").Formula = Sheets("Check").Range("j4:p20").Formula .....but this only copies formulae from one sheet to another within the same book. Please help! Sheets("New Checksheet").Range("j4:p20").Formula = Sheets("Checksheet").Range("j4:p20").Formula |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Exact Formula
For the lack of a better way ... I cheat ... I place an aprostrophe ( ' ) in
front of the equals ( = ) sign so the Formula looks like text ... Then I copy/paste ... to the new WorkBook ... Remove the aprotrophe ... your done ... HTH ... Kha "bongiman" wrote: Hi, I want to copy a range of formulae from one work book to another identicaly formatted workbook but i do not wish the formulae to link back into the old spreadsheet. Both workbooks, Book1 & Book2 have a Volumes sheet and a Check sheet and when i copy the formulae from Check on Book1 to Book 2, the fomulae still point to the Volumes sheet on Book1 instead of the one on the same book. What is the best way to do this? The closest i've come is by using the following formula: Sheets("New Check").Range("j4:p20").Formula = Sheets("Check").Range("j4:p20").Formula ....but this only copies formulae from one sheet to another within the same book. Please help! Sheets("New Checksheet").Range("j4:p20").Formula = Sheets("Checksheet").Range("j4:p20").Formula |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Exact Formula
"bongiman" wrote:
The closest i've come is by using the following formula: Sheets("New Check").Range("j4:p20").Formula = Sheets("Check").Range("j4:p20").Formula With both workbooks open in the same Excel instance: Workbooks("Book2").Sheets("New Check").Range("j4:p20").Formula = _ Workbooks("Book1").Sheets("Check").Range("j4:p20") .Formula ----- original message ----- "bongiman" wrote in message ... Hi, I want to copy a range of formulae from one work book to another identicaly formatted workbook but i do not wish the formulae to link back into the old spreadsheet. Both workbooks, Book1 & Book2 have a Volumes sheet and a Check sheet and when i copy the formulae from Check on Book1 to Book 2, the fomulae still point to the Volumes sheet on Book1 instead of the one on the same book. What is the best way to do this? The closest i've come is by using the following formula: Sheets("New Check").Range("j4:p20").Formula = Sheets("Check").Range("j4:p20").Formula ....but this only copies formulae from one sheet to another within the same book. Please help! Sheets("New Checksheet").Range("j4:p20").Formula = Sheets("Checksheet").Range("j4:p20").Formula |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exact Copy | Excel Discussion (Misc queries) | |||
Copy exact value from one cell to new formula in another cell | Excel Discussion (Misc queries) | |||
Exact formula copy. | Excel Discussion (Misc queries) | |||
How to do the exact copy of a formula | Excel Worksheet Functions | |||
How to copy cells with keeping exact formula intact | Excel Discussion (Misc queries) |