Forum Discussion
Excel formulas
Hi, Is there a way to enter a number in a cell - "income" then hit "enter" button and it disappears summing all entered numbers in next cell "quantity" ?
I don't understand! Where do you want the entered number to "Disappear" to? You could make it "disappear" in many ways - conditional format to set font color the same as background color;; use VBA to Undo your entry; use VBA to move it somewhere else; etc.
Disappear to quantity. It's like I have 1 cookie in my hand (income) then I put it in a jar (hit enter) with 5 cookies, my hand became empty and the jar have +1 cookie. Overall quantity in a jar bacame 6.
- You may need a macro, something like:
Private Sub Worksheet_Change (ByVal Target As Range)
Range("B2").Value = Range("B2").value + Range("A2").value
End Sub
This will create a running total whether you press Enter or click away from cell A2.
Cheers
DamienHmm, I've never worked with macros before. Would it be hard to you to explain it in more detail or step by step?
