I am working in Excel 07. I have 12 sheets - January, February, March...etc. I have a number of formula in the second sheet that read =SUM(AH22+January!AH23)
This formula adds up a year-to-date balance. I would like to copy this formula to the rest of the sheets but have it automatically reflect the month before. For example, the March sheet should read
When I do a copy - past, paste special, or ctrl and pointer method it doesn't change the month to reflect the next worksheet; I hope this makes sense. Anyway, I know that it is no big deal to manually type these formulas in. I am just wondering if there is a way to do it automatically.
Any suggestions would be greatly appreciated.