Question on copying formulas

M

Meenie

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Count If Formula Question 1
Copying Excel formulas from one Workbook to another 3
Worksheet relative reference 3
How can I transfer formulas between 2 Excel workbooks? 4
How can I make a running total change in a new cell 3
Reference other worksheet 4
How do I edit several formulas at one time in a worksheet? 2
Need help with "blank" in formula 10

Top