| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
not necessarily a code question, but
i have a workbook with about 300 lines of formulas. i would like to copy them to
another workbook. but when i do, the formulas always link back to the original workbook. any way around this? -- Gary |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
not necessarily a code question, but
Gary:
I think the practice is to Highlight/Select your range (of formulas) and to the Edit, Replace routine where, say: In the Find What Box enter = and in the Replace with $ Then Copy and paste -- Then reverse Process in the Destination and the Source!! HTH, Jim May "Gary Keramidas" wrote: i have a workbook with about 300 lines of formulas. i would like to copy them to another workbook. but when i do, the formulas always link back to the original workbook. any way around this? -- Gary |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
not necessarily a code question, but
ok, thanks for the tip, jim
-- Gary "Jim May" wrote in message ... Gary: I think the practice is to Highlight/Select your range (of formulas) and to the Edit, Replace routine where, say: In the Find What Box enter = and in the Replace with $ Then Copy and paste -- Then reverse Process in the Destination and the Source!! HTH, Jim May "Gary Keramidas" wrote: i have a workbook with about 300 lines of formulas. i would like to copy them to another workbook. but when i do, the formulas always link back to the original workbook. any way around this? -- Gary |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
not necessarily a code question, but
Not sure I'd use a $. Consider the formula
=$E$5 becomes $$E$5 trying to change it back generates an error on my machine. "Jim May" wrote: Gary: I think the practice is to Highlight/Select your range (of formulas) and to the Edit, Replace routine where, say: In the Find What Box enter = and in the Replace with $ Then Copy and paste -- Then reverse Process in the Destination and the Source!! HTH, Jim May "Gary Keramidas" wrote: i have a workbook with about 300 lines of formulas. i would like to copy them to another workbook. but when i do, the formulas always link back to the original workbook. any way around this? -- Gary |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
not necessarily a code question, but
Good Catch JMB; I need to remember that (for next time).
Thanks, Jim "JMB" wrote: Not sure I'd use a $. Consider the formula =$E$5 becomes $$E$5 trying to change it back generates an error on my machine. "Jim May" wrote: Gary: I think the practice is to Highlight/Select your range (of formulas) and to the Edit, Replace routine where, say: In the Find What Box enter = and in the Replace with $ Then Copy and paste -- Then reverse Process in the Destination and the Source!! HTH, Jim May "Gary Keramidas" wrote: i have a workbook with about 300 lines of formulas. i would like to copy them to another workbook. but when i do, the formulas always link back to the original workbook. any way around this? -- Gary |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
not necessarily a code question, but
You keep the equals sign in there, so you change = to $= (or x=,
whatever you like), then you don't suffer the problem of $$. Pete Jim May wrote: Good Catch JMB; I need to remember that (for next time). Thanks, Jim "JMB" wrote: Not sure I'd use a $. Consider the formula =$E$5 becomes $$E$5 trying to change it back generates an error on my machine. "Jim May" wrote: Gary: I think the practice is to Highlight/Select your range (of formulas) and to the Edit, Replace routine where, say: In the Find What Box enter = and in the Replace with $ Then Copy and paste -- Then reverse Process in the Destination and the Source!! HTH, Jim May "Gary Keramidas" wrote: i have a workbook with about 300 lines of formulas. i would like to copy them to another workbook. but when i do, the formulas always link back to the original workbook. any way around this? -- Gary |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
not necessarily a code question, but
i knew not to use a $, but the character addition was what i needed
-- Gary "JMB" wrote in message ... Not sure I'd use a $. Consider the formula =$E$5 becomes $$E$5 trying to change it back generates an error on my machine. "Jim May" wrote: Gary: I think the practice is to Highlight/Select your range (of formulas) and to the Edit, Replace routine where, say: In the Find What Box enter = and in the Replace with $ Then Copy and paste -- Then reverse Process in the Destination and the Source!! HTH, Jim May "Gary Keramidas" wrote: i have a workbook with about 300 lines of formulas. i would like to copy them to another workbook. but when i do, the formulas always link back to the original workbook. any way around this? -- Gary |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| question on VB code | Excel Discussion (Misc queries) | |||
| Formula for selecting the second row down (Not necessarily row "2" | Excel Worksheet Functions | |||
| Another code question | Excel Discussion (Misc queries) | |||
| VBA code question?! | Excel Programming | |||
| Code Question | Excel Programming | |||
Linear Mode
