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 get 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 column have it add to the total points, keep that running total, and clear the 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 points from the Total Points, then clear the number i entered in the minus field, saving the running total...

I'm fairly good with the basics of excel, but i couldn't think of a formula that would keep a running total, while clearing the entered 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!
==============================================


"chris_" <[email protected]> wrote in
message news:[email protected]...
>
> At work we have a competition and we keep up with a set of points we get
> 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 column
> have it add to the total points, keep that running total, and clear the
> 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 points
> from the Total Points, then clear the number i entered in the minus
> field, saving the running total...
>
> I'm fairly good with the basics of excel, but i couldn't think of a
> formula that would keep a running total, while clearing the entered
> information.
>
> Thanks in advance!
>
>
> --
> chris_
> ------------------------------------------------------------------------
> chris_'s Profile:
http://www.excelforum.com/member.php...o&userid=25009
> View this thread: http://www.excelforum.com/showthread...hreadid=385357
>

[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.




--
HTH

Bob Phillips

"chris_" <[email protected]> wrote in
message news:[email protected]...
>
> At work we have a competition and we keep up with a set of points we get
> 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 column
> have it add to the total points, keep that running total, and clear the
> 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 points
> from the Total Points, then clear the number i entered in the minus
> field, saving the running total...
>
> I'm fairly good with the basics of excel, but i couldn't think of a
> formula that would keep a running total, while clearing the entered
> information.
>
> Thanks in advance!
>
>
> --
> chris_
> ------------------------------------------------------------------------
> chris_'s Profile:
http://www.excelforum.com/member.php...o&userid=25009
> View this thread: http://www.excelforum.com/showthread...hreadid=385357
>

[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>

--
HTH

Bob Phillips

"chris_" <[email protected]> wrote in
message news:[email protected]...
>
> 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?
>
>
> --
> chris_
> ------------------------------------------------------------------------
> chris_'s Profile:
http://www.excelforum.com/member.php...o&userid=25009
> View this thread: http://www.excelforum.com/showthread...hreadid=385357
>

[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

"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> 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>
>
> --
> HTH
>
> Bob Phillips
>
> "chris_" <[email protected]> wrote in
> message news:[email protected]...
> >
> > 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?
> >
> >
> > --
> > chris_
> > ------------------------------------------------------------------------
> > chris_'s Profile:
> http://www.excelforum.com/member.php...o&userid=25009
> > View this thread:
http://www.excelforum.com/showthread...hreadid=385357
> >
>
>

[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.