I have some worksheets in one workbook that are linked to worksheets in
another workbook.
I know that when I enter the link, I can drag it down and it changes the
info to match.
My question is when I make the two workbooks for the next month, is there an
easy way to make the links update to the next month without having to go to
each sheet and manually changing the formula (change the month name so it
links to the new workbook instead of the old workbook) and then dragging the
new formula down on each sheet??
I have Excel 2003.
Thanks Meenie

Nevermind, I figured it out... Edit/Replace!!! duh :)

"Meenie" wrote:

I have some worksheets in one workbook that are linked to worksheets in
another workbook.
I know that when I enter the link, I can drag it down and it changes the
info to match.
My question is when I make the two workbooks for the next month, is there an
easy way to make the links update to the next month without having to go to
each sheet and manually changing the formula (change the month name so it
links to the new workbook instead of the old workbook) and then dragging the
new formula down on each sheet??
I have Excel 2003.
Thanks Meenie