Bob's code will do what you want but just keep in mind that you have no audit
trail to keep track of what is entered and no way to recover from an error in
data entry.


Gord Dibben MS Excel MVP

On Thu, 3 Jan 2008 21:31:12 -0000, "Bob Phillips" wrote:

Clear out column D first and add this code

Private Sub Worksheet_Change(ByVal Target As Range)
Const WS_RANGE As String = "B:B" '<== change to suit

On Error GoTo ws_exit
Application.EnableEvents = False

If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
With Target
.Offset(0, 2).Value = .Offset(0, 2).Value + .Value
End With
End If

ws_exit:
Application.EnableEvents = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.