Adding A Column

[BACH]

Is there anyway to have excel automatically add new column into a formula.

Like =B69-SUM(C69:BS70) and I add in a new column it would be BS71. Is there
something to make excel automatically pick this new cell up an add it to my
formula?

 

[Max]

Just include an empty col to the right in your formula:
=B69-SUM(C69:BT70)
then do the insert>col on that empty, rightmost col (col BT)
and the formula will adjust auto
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik

 

[BACH]

Can you please explain the insert>col. I do not understand, and have never
used this.

 

[Gord Dibben]

BACH

I think you have typo to start with..........

You speak of inserting a column but you want to include BS71 which is one
ROW down from BS70.

Which do you mean? Insert column or insert row?


Gord Dibben MS Excel MVP

 

[Max]

Can you please explain the insert>col ...

Excel inserts new cols to the left of the insert point. When you click on
say, BT1, then you click the menu: Insert > Columns, Excel will insert a
"new" col BT (the "previous" col BT will shift to the right).

And the SUM formula: =B69-SUM(C69:BT70)
will then auto-adjust itself to cover the "new" col BT,
ie it'll become: =B69-SUM(C69:BU70)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---