If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
changing source name constantly
Is this possible? Want to have a Master Document (source)
feeding into several sheets of a Destination Document so using links (cell links and paste special several cell links). All ok and updates. However, want to rename the Master Document to a different Month Name at end of every month. Still want the Destination document to know this and update accordingly so what was MasterJan has changed to MasterFeb and I want the destination sheets to know that and update. Is there any way at all? Help much appreciated. Thanks. Sally |
#2
|
|||
|
|||
changing source name constantly
Sally t wrote:
However, want to rename the Master Document to a different Month Name at end of every month. Still want the Destination document to know this and update accordingly so what was MasterJan has changed to MasterFeb and I want the destination sheets to know that and update. Is there any way at all? If you have the destination document open and with the Master document active File / Save As / MasterFeb then the links in the destination document will automatically be changed. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#3
|
|||
|
|||
changing source name constantly
-----Original Message----- Is this possible? Want to have a Master Document (source) feeding into several sheets of a Destination Document so using links (cell links and paste special several cell links). All ok and updates. However, want to rename the Master Document to a different Month Name at end of every month. Still want the Destination document to know this and update accordingly so what was MasterJan has changed to MasterFeb and I want the destination sheets to know that and update. Is there any way at all? Help much appreciated. Thanks. Sally . Hi Sally My guess would be using a macro. As you know if you open all spreadsheets that are linked to the master, then rename the master (from Jan to feb) Excell automatically updates that link in all speadsheets. So if you didn't want to do this arduous task each time, you can set up a macro that will do it for you, then assign a button on the spreadsheet to activate the macro (all in help), but basically when you press record on a macro, it will record every action you do until you press stop. |
#4
|
|||
|
|||
changing source name constantly
Great advice. Thanks. Think I'll create a workspace with
the relevant books that way they will always open together so if I rename the master at any stage, the links will automatically update. Thanks again! Sally T -----Original Message----- Sally t wrote: However, want to rename the Master Document to a different Month Name at end of every month. Still want the Destination document to know this and update accordingly so what was MasterJan has changed to MasterFeb and I want the destination sheets to know that and update. Is there any way at all? If you have the destination document open and with the Master document active File / Save As / MasterFeb then the links in the destination document will automatically be changed. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup . |
Thread Tools | |
Display Modes | |
|
|