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
.
|