Formula update automatically

B

Bhuktar S

Please look into the formula & suggest.
The excel sheet is fille-in as below:
Column A B C D
Row 1 2 6 5
Row 2 20 30 90 D2=A$1*A2+B$1*B2+C$1*C2
Row 3 2 4 8 D3=A$1*A3+B$1*B3+C$1*C3
& so on for further rows.

What I need is, if a column is added between, say, B & C, then th
formula in D column should update for the added column & similarly fo
deleted column.

Is there a way?
I would prefer excel formula solution. If code is the only solution
please write the complete code. The undo button should not becom
inactive, if code is employed, when a cell is edited.

Hope somebody has solution or suggestions
 
B

Bob Phillips

D2: =SUMPRODUCT(A$1:C$1,A2:C2)
D3: =SUMPRODUCT(A$1:C$1,A3:C3)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
F

Frank Kabel

Hi
in D2 enter the folowing formula
=SUMPRODUCT(A$1:C$1,A2:C2)
and copy this down for all rows
 
B

Bob Phillips

The SUMPRODUCT twins!

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
F

Frank Kabel

lol

--
Regards
Frank Kabel
Frankfurt, Germany

Bob Phillips said:
The SUMPRODUCT twins!

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
Click to expand...
 
Top