Hi

You have found the problem with the accumulator method - there is no track
of what you have typed! I would suggest using a single column to enter your
data - and if it screws up you can see where the problem is and sort it out.

Andy.

"tipsy" <tipsy.1rgkcy@ wrote in message
...

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