Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a column and recalculate formula automatically
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a column and recalculate formula automatically
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 On Oct 29, 8:15*pm, BACH wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a column and recalculate formula automatically
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a column and recalculate formula automatically
This creates a circular reference.
"TomPl" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a column and recalculate formula automatically
did you put the formula in P13 and delete the formula from O?
"BACH" wrote: This creates a circular reference. "TomPl" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula when copied into a new cell doesn't recalculate | Excel Discussion (Misc queries) | |||
How to get Escel to Recalculate a formula if the answer does not meat criteria | Excel Worksheet Functions | |||
Recalculate Formula when field value changes | Excel Discussion (Misc queries) | |||
Can you make excel automatically recalculate every x seconds? | Excel Discussion (Misc queries) | |||
Adding TR to the end of each value in a column..formula | Excel Worksheet Functions |