Adding a column and recalculate formula automatically

  • Thread starter Thread starter BACH
  • Start date Start date
B

BACH

Is there anyway to have excel automatically add new column into a formula.
Example =B13-SUM(C13:M13) and I add in a new column it would be N13 my
formula is located in O13. Is there something to make excel automatically
pick this new cell up an add it to my formula?
 
If you insert the new column within the range, eg a new column M, then
the formula will automatically adjust to include column N. Then use
copy/paste to copy the whole of column N back into column M and then
highlight column N and press the <delete> key to empty all the cells -
do not use cut/paste.

Hope this helps.

Pete
 
Put your formula in P13.
Change the formula to =B13-SUM(C13:O13)
Column O will remain blank.
Add new column before column O and the new column will automatically be
included in the formula.
You cannot hide column O because then you will not be able to add a column
before it.
Make Column O real narrow to separate the data from the formula and to
remind you to insert columns before it.

Tom
 
Back
Top