Excell Help

[Robot]

ROBOT
I wish to keep a running total in one cell of numbers entered into another similar to a calculator. Any ideas would help. Tried count and sum functions.
Tom the ROBOT

[Shaun]

Why won't this work.
in cell A1 type
=sum(A2:A100)

[Robot]

Tnks for reply.No doesn,t work as I am changing cell A2 repeatedly. Not proceeding down the column.
ROBOT

[Shaun]

Not sure about a formula but here is a macro that will do it

Sub Calculate()
Sheets("Sheet1").Range("B3").Value = Sheets("Sheet1").Range("B2").Value
End Sub

Sub Reset()
Sheets("Sheet1").Range("B1").Value = 0
Sheets("Sheet1").Range("B3").Value = 0
Sheets("Sheet1").Range("B3").Value = Sheets("Sheet1").Range("B2").Value
End Sub


I have included a sheet so you can see how it works, i also included a reset code.

There is some code in cell B2 formatted to white so it is invisible.

[Robot]

Many thanks for your macro.I used it on your reply and that is what I wanted. Next question As I have never entered macros and know nothing about them other than they allow many key strokes with just one operation how do I enter it in my worksheet.Too old now to learn this new method (84) All help would be appreciated.Also love your threads in the gambling and system forum.
Regards once again
Tom the ROBOT

[Shaun]

If you have my sheet open you can right click on a sheet tab and select "view code" then click on "Moduels" then "Moduel 1"

Depending on the type of macro you create they would go in different places but basic macros can go here.

They do a lot more than just emulate keystrokes every thing that is typed as a formula can be used as a macro so the sheet contains no formulas and runs super fast.

I don't do this myself but use macro to perform things i can't do in code, my main use of them over the years has been for extracting information from web pages i have imported and to automate these tasks.