OZmium Sports Betting and Horse Racing Forums

OZmium Sports Betting and Horse Racing Forums (http://forums.ozmium.com.au/index.php)

- General Topics (http://forums.ozmium.com.au/forumdisplay.php?f=59)

- - Excell Help (http://forums.ozmium.com.au/showthread.php?t=23225)

Robot

14th January 2012 11:26 AM

Excell Help

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

14th January 2012 11:46 AM

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

Robot

14th January 2012 12:19 PM

SHAUN

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

Shaun

14th January 2012 01:45 PM

1 Attachment(s)

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

Code:


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

16th January 2012 10:16 AM

SHAUN

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

16th January 2012 11:59 AM

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.

All times are GMT +10. The time now is 06:04 AM.