excel - add the value of a cell to another cell and then clear it -

i have been unable find way create kind score tracker.

i want have 2 cells... 1 capture value , 1 keep running total.

this scenario:

cell b1 contain running total of points scored. cell a1 allow user input score.

i need value entered in a1 added current total in b1. once b1 has been updated added value, cell a1 should cleared ready next score.

can done?

thanks ideas can offer.

try in 1 of worksheet modules ...

private bignoreevent boolean private sub worksheet_change(byval target range)     if bignoreevent exit sub     bignoreevent = true     cells(1, 2) = cells(1, 2) + cells(1, 1)     cells(1, 1) = ""     bignoreevent = false end sub 

by means try without bignoreevent bit follows can see why necessary. recommend after have saved current work ...

private sub worksheet_change(byval target range)     cells(1, 2) = cells(1, 2) + cells(1, 1)     cells(1, 1) = "" end sub 

... because crash excel ... have been warned!