Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Replicating Formulas between excel files
Hi there,
Does anyone know how I can replicate formulas (verbatim) between difference excel files? I've tried to cut and paste between the separate files, but to my dismay it makes a reference to the original file. Regards, Nickchups |
#2
|
|||
|
|||
The best procedure depends on how many you're trying to copy.
For one or two, you can select the *entire* formula in the formula bar, right click and choose "Copy", then hit <Enter. Now you can navigate to wherever you wish, and Paste it as many times and/or places you want. For numerous formulas, *unformulate* them by replacing the equal sign with a unique character(s), by using "Edit & Replace", and then copy and paste as regular text to your new location, and then reverse the procedure to return the equal sign and make them formulas again. Make sure the unique replacement is *unique*. Something like carats and backslashes: ^\^\^ -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Nickchups" wrote in message ... Hi there, Does anyone know how I can replicate formulas (verbatim) between difference excel files? I've tried to cut and paste between the separate files, but to my dismay it makes a reference to the original file. Regards, Nickchups |
#3
|
|||
|
|||
Thanks RagDyer.
That's a very clever solution. I just tested it with a macro and it works a treat. Given that I have many of these to do. You've saved me a heap of time and effort. Thankyou kindly =) "RagDyer" wrote: The best procedure depends on how many you're trying to copy. For one or two, you can select the *entire* formula in the formula bar, right click and choose "Copy", then hit <Enter. Now you can navigate to wherever you wish, and Paste it as many times and/or places you want. For numerous formulas, *unformulate* them by replacing the equal sign with a unique character(s), by using "Edit & Replace", and then copy and paste as regular text to your new location, and then reverse the procedure to return the equal sign and make them formulas again. Make sure the unique replacement is *unique*. Something like carats and backslashes: ^\^\^ -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Nickchups" wrote in message ... Hi there, Does anyone know how I can replicate formulas (verbatim) between difference excel files? I've tried to cut and paste between the separate files, but to my dismay it makes a reference to the original file. Regards, Nickchups |
#4
|
|||
|
|||
Appreciate the feed-back.
-- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "Nickchups" wrote in message ... Thanks RagDyer. That's a very clever solution. I just tested it with a macro and it works a treat. Given that I have many of these to do. You've saved me a heap of time and effort. Thankyou kindly =) "RagDyer" wrote: The best procedure depends on how many you're trying to copy. For one or two, you can select the *entire* formula in the formula bar, right click and choose "Copy", then hit <Enter. Now you can navigate to wherever you wish, and Paste it as many times and/or places you want. For numerous formulas, *unformulate* them by replacing the equal sign with a unique character(s), by using "Edit & Replace", and then copy and paste as regular text to your new location, and then reverse the procedure to return the equal sign and make them formulas again. Make sure the unique replacement is *unique*. Something like carats and backslashes: ^\^\^ -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Nickchups" wrote in message ... Hi there, Does anyone know how I can replicate formulas (verbatim) between difference excel files? I've tried to cut and paste between the separate files, but to my dismay it makes a reference to the original file. Regards, Nickchups |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel files in separate program windows | Excel Discussion (Misc queries) | |||
Importing multiple Text files into Excel 2003 | Excel Discussion (Misc queries) | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
Open excel files | Excel Discussion (Misc queries) | |||
Problems opening Excel files using DFS links | Excel Discussion (Misc queries) |