Link to home
Start Free TrialLog in
Avatar of Shaft960
Shaft960

asked on

How do I copy this formula to the rest of the sheets but have it automatically reflect the month before?

Hi all,

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

=SUM(AH22+February!AH23).

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.

LGX
Avatar of Shaft960
Shaft960

ASKER

To clarify, I have a couple of formulas that refer to the previous month: not just   =SUM(AH22+January!AH23)
The easiest way is to make copies of the second sheet and use a small macro to find and replace all the names. Would that help?

Sid
ASKER CERTIFIED SOLUTION
Avatar of SiddharthRout
SiddharthRout
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you, much obliged.