About Us

Yossy

thanks, i really appreciate it.

"Don Guillett" wrote:

Not quite sure what you want but these should cover it

Sub showvalueandsumifg3TEXT()
MV = Range("g3") & "+" & Range("g20")
MsgBox MV
Range("G3") = MV
End Sub
Sub showvalueandsumifg3FORMULA()
MV = Range("g4").Formula & "+" & Range("g20")
MsgBox MV
Range("G5") = MV
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Yossy" wrote in message
...
Please all help totally appreciated. I want to add values to another value
in
another cell but want to see the values as they add up.

E.g
Cell G3 = E26+200+500
Gell G20 = 100
I want to add G20 to G3: Is it possible to leave the values as G3=
E26+200+500+100 and even show the new value added of 100. THe code below
just sums up the total without showing the breakdown of values added so
far.

With .Range("G3")
.Value = .Value + ws.Range("G20").Value
End With
With .Range("G10")
.Value = .Value + ws.Range("G21").Value
End With

Again is it possible to have G3 =E26+200+500+100 in G3 once code is
executed. This way I see the values added not the whole added nos. This I
need for G10 too when I add G21 value.

Thanks so much for helping out.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Balances	GA85	Excel Discussion (Misc queries)	8	November 15th 08 10:17 PM
Calculating Average Daily Balances	[email protected]	Excel Programming	1	November 13th 08 06:51 AM
Showing zero balances	Ed	Excel Discussion (Misc queries)	2	August 9th 05 06:41 AM
excel template for calculating trial balances and adjusting entri.	yesterdaytoday11	Excel Worksheet Functions	2	November 24th 04 06:25 PM
How to link endings balances to beginning balances on different sh	judyskiskd	Excel Worksheet Functions	1	October 28th 04 07:21 PM

Menu

About Us