Macros - add column, update formula

[sgp]

Hello..

On the attached example I have some costs shown as:
- Original costs - user enters info.
- Interest 1 , 2, 3 - calculated by formula
- Total Costs - user inputs
- Difference - calculated by formula

Now what I would like is a macro that can add a 'Interest' column i.e. Interest 4, but also update the 'difference' formula between the 'Actual Costs' and the current 'Interest' rate (interest 4).

Is there a way of doing this through a formula?? so that when I add Interest 5 using the same macro, the formula is automatically updated and does not take interest 4 into account.

Hope i've explained this right!

Many thanks!

[TMS]

You could change the formula in F2 to:

=OFFSET($F2,0,-2)-OFFSET($F2,0,-1)

That should allow you to insert a column without needing to adjust the formula.

Regards

[sgp]

Thanks a ton! That works great!!!

[TMS]

You're welcome. Thanks for the rep. TMS