i know this has to be so easy -newb

[chris_]

At work we have a competition and we keep up with a set of points we ge
each day.

I want to create a worksheet that looks like this:

Name | + | - | Total Points


I want to be able to simply enter 3(or any number) in the Plus colum
have it add to the total points, keep that running total, and clear th
3 that i put in there so it will be ready for tomorrow.

The same goes for the minus, I want to be able to deduct these point
from the Total Points, then clear the number i entered in the minu
field, saving the running total...

I'm fairly good with the basics of excel, but i couldn't think of
formula that would keep a running total, while clearing the entere
information.

Thanks in advance

 

[RagDyer]

It's not the best way to approach this.
You have *no* record of past entries, so how can you check if a mistake was
made, or even if an entry was forgotten to be made.

However, check out this link of John McGimpsey:

http://www.mcgimpsey.com/excel/accumulator.html
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[Bob Phillips]

Private Sub Worksheet_Change(ByVal Target As Range)

On Error GoTo ws_exit:
Application.EnableEvents = False
With Target
If .Column = 2 Then
.Offset(0, 2).Value = .Offset(0, 2).Value + .Value
.Value = ""
ElseIf Target.Column = 3 Then
.Offset(0, 1).Value = .Offset(0, 1).Value - .Value
.Value = ""
End If

End With

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.

 

[chris_]

ok, i wasn't aware that you could use VB with excel... I see that I have
a sheet called "ThisWorkbook" and I added the code from Bob's post, but
i'm not sure what actions I need to do to make it work with my
worksheet...


could someone please give the noob some kind of step by step help on
how to get this working?

 

[Bob Phillips]

Chris,

The code is worksheet code, not workbook code. Check the instructions I gave
at the end of the post to see how to install it.

And it is VBA, Visual Basic for Application <g>

 

[Bob Phillips]

.... and then just enter values into the + or - columns (B & C in my code),
and watch the totals (D) update.

--
HTH

Bob Phillips

Chris,

The code is worksheet code, not workbook code. Check the instructions I gave
at the end of the post to see how to install it.

And it is VBA, Visual Basic for Application <g>

 

[chris_]

thanks so much bob, everything is working great... I missed the part on
right clicking on the worksheet tab, so that was my problem.

Thanks again.