D
Duffy
need to add cell A1 to cell B1 and have the total reside in B1
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ron de Bruin
Hi Duffy
Only possible with code
Is that a option for you ?
Only possible with code
Is that a option for you ?
D
Duffy
What do you mean "code"?
Ron de Bruin said:Hi Duffy
Only possible with code
Is that a option for you ?
D
Duffy
D
Dave F
Cells can't normally both contain a value and a formula. Typically, you
would enter in cell C1 =A1+B1
But you want to enter in B1 =B1+A1
The only way to do that is with VBA code, not normal Excel functions.
Dave
would enter in cell C1 =A1+B1
But you want to enter in B1 =B1+A1
The only way to do that is with VBA code, not normal Excel functions.
Dave
R
Ron de Bruin
VBA code line looks like this then
Range("B1").Value = Range("B1").Value + Range("A1").Value
Range("B1").Value = Range("B1").Value + Range("A1").Value
G
Gord Dibben
Why do you "need" the total to reside in B1?
This method is very prone to errors which leave no "paper trail" for future
auditing.
You're always better off using a third cell to Sum 2 others.
See this google search result for more info, including code.
http://snipurl.com/1dmfi
Gord Dibben MS Excel MVP
This method is very prone to errors which leave no "paper trail" for future
auditing.
You're always better off using a third cell to Sum 2 others.
See this google search result for more info, including code.
http://snipurl.com/1dmfi
Gord Dibben MS Excel MVP