Thanks! I got it all in. But there is one thing with this system that
is bad. If you aren't paying attention you could end up screwed up the
count. I'm just wondering if I can extend my pile column into another
cell but that cell states the previous number that was in the pile cell
before it was changed. so far I'm working with...

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
If .Address(False, False) = "A1" Then
If IsNumeric(.Value) Then
Application.EnableEvents = False
Range("B1").Value = Range("B1").Value + .Value
Application.EnableEvents = True
End If
End If
If .Address(False, False) = "C1" Then
If IsNumeric(.Value) Then
Application.EnableEvents = False
Range("D1").Value = Range("D1").Value + .Value
Application.EnableEvents = True
End If
End If
End With
End Sub

Which means anything I enter into a1 will update b1's pile. And
anything into c1 will update d1's pile. Could I get lets say e1 to
display what d1 had before i typed a new number into c1 (incase of a
typo)


--
tipsyPosted from http://www.pcreview.co.uk/ newsgroup access