One spreadsheet in my workbook holds all financial statements, printable. The formulas pull from the other spreadsheets which are updated monthly by pasting data into the next column.
I need the cells referenced in some formulas to move one column right each month.
For example:
In spreadsheet "Reporting Package"
Cash ='Trial Balance'!AJ491
A/R ='Trial Balance'!AJ493
Contributions ='Trial Balance'!AJ270-'Trial Balance'!V270
I need all these formulas to move from referencing column AJ to AK, (but to not change column V in the contributions formula). Next month, I'll need to move from AK to AL, still not changing column V.
Thus far, I've been running a "find and replace" and writing:
Find: 'Trial Balance'!AJ
Replace: 'Trial Balance'!AK
This works fine, but there are many of these to do. Find: Budget'!BC, Revenue'!AJ, Trial Balance'!AI, and so on.
Is there an easier way? I find it difficult to see how a macro could handle this without needing to be re-written each month. In that case, I may as well do it as I currently do.
Any input is greatly appreciated.
Bookmarks