Macro to increase formulas from the previous month's workbooks into next month's workbook

Hi,

I have to create a workbook for every month in the year, within each workbook there is 13 tabs. I have to have each month build on the previous month but if I copy and paste the formula from the previous month I still have to edit the formula for the correct previous month. I.e. if i am working in the month of May and copy April's formulas, I still have to go in and edit each formula to change from March to April. Is there a macro that I can use that automatically update the formulas?

Thanks!

You could use Excel's Replace function (Ctrl + H)

• Select all the pasted cells with "March" formulas
• Ctrl+H to open the Replace dialog
  • Replace what: March
  • Replace with: April
  • Look In: Formulas
  • Click Replace All