Update a formula
Posted on 2011-02-16
I have a lot of formulas that I need to change. Example below:
The original formula says:
I need it to say:
How can I automate adding those sections to the formula? I can't do a drag or copy/paste because there are different sum ranges (the formulas sum 4 or 5 cells, it's not consistent).
I tried using a macro, but that doesn't seem to work because it bases the formula off the current cell reference, instead of what is currently in the cell formula.
Can you help? Let me know if you need more info.