Okay....I have 2 workbooks that are linked to each other, easy enough.....
Lets say I have a workbook called "09-05 A" and "09-05 B" and each workbook
has a spreadsheet for each day of the month. Now, for the month of September,
cell one in sheet A contains the link "[09-05 B]01", and so on for the rest
of the month. Now, for the month of October, I want to change the value to "
[10-05 B]01", and so on for every day of the month. Is there a way to update
every link at once to just change the month, and not everything else? I know
this may sound confusing, and I'll clarify if needed.....Thanks!


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...links/200509/1

Edit / Replace / [09- (with) [10- / Replace All
?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup