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.aspx/excel-links/200509/1
|
