Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying formulas between workbooks - help needed
I have two workbooks with the same set of identical sheets. One is a master
template, the other is a version of the master with real data in it (the slave). I want to change some formulas in one sheet in the master & when I'm happy they work overlay them into the equivalent sheet in the slave so they act upon the data in there. The formulas I want to change contain references to cells in other sheets in the workbook (e.g. =Sheet1!G$70...). My problem is that when I copy the formulas from the master to the slave it precedes them with the workbook name of the master (e.g. ='[Master.xls]Sheet1!G$70...) which I don't want it to do, I just want it to retain its reference to Sheet1 so that it references that same sheet in the slave. Is there a way of doing this? I have tried copying/pasting the formulas and moving/copying the entire sheet but get the same result either way. I have a similar issue with a Form button when I copy the entire sheet. When copied from Mater to Slave the assigned macro refers back to the master. The same macro exists in the slave and I want it to refer to that. Again, is this possible? Dave J |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying formulas between workbooks - help needed
for the links you can go to to the edit menu then links you can change source
and navigate back to the slave instead of the master.....that may do the form buttons as well -- paul remove nospam for email addy! "DaveJ" wrote: I have two workbooks with the same set of identical sheets. One is a master template, the other is a version of the master with real data in it (the slave). I want to change some formulas in one sheet in the master & when I'm happy they work overlay them into the equivalent sheet in the slave so they act upon the data in there. The formulas I want to change contain references to cells in other sheets in the workbook (e.g. =Sheet1!G$70...). My problem is that when I copy the formulas from the master to the slave it precedes them with the workbook name of the master (e.g. ='[Master.xls]Sheet1!G$70...) which I don't want it to do, I just want it to retain its reference to Sheet1 so that it references that same sheet in the slave. Is there a way of doing this? I have tried copying/pasting the formulas and moving/copying the entire sheet but get the same result either way. I have a similar issue with a Form button when I copy the entire sheet. When copied from Mater to Slave the assigned macro refers back to the master. The same macro exists in the slave and I want it to refer to that. Again, is this possible? Dave J |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Workbooks and keeping the formulas only? | Excel Discussion (Misc queries) | |||
Copy formulas between workbooks without copying links | Excel Discussion (Misc queries) | |||
Help Needed With Copying Formulas | Excel Worksheet Functions | |||
Copying formulas between workbooks | Excel Discussion (Misc queries) | |||
Copying formulas, formats, and sheet names across workbooks | Excel Programming |