Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
Reload this Page Excell Help
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 14th January 2012, 11:26 AM
Robot Robot is offline
Member
  
Join Date: Jan 2011
Posts: 27
Default 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
Reply With Quote
  #2  
Old 14th January 2012, 11:46 AM
Shaun Shaun is offline
Member
  
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
Default
Why won't this work.
in cell A1 type
=sum(A2:A100)
Reply With Quote
  #3  
Old 14th January 2012, 12:19 PM
Robot Robot is offline
Member
  
Join Date: Jan 2011
Posts: 27
Default SHAUN
Tnks for reply.No doesn,t work as I am changing cell A2 repeatedly. Not proceeding down the column.
ROBOT
Reply With Quote
  #4  
Old 14th January 2012, 01:45 PM
Shaun Shaun is offline
Member
  
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
Default
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.
Attached Files
File Type: xlsm Calculator.xlsm (18.5 KB, 528 views)
Reply With Quote
  #5  
Old 16th January 2012, 10:16 AM
Robot Robot is offline
Member
  
Join Date: Jan 2011
Posts: 27
Default 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

Reply With Quote
  #6  
Old 16th January 2012, 11:59 AM
Shaun Shaun is offline
Member
  
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
Default
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.
Reply With Quote
Reply

« Previous Thread | Next Thread »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



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

Contact Us - OZmium Pty Ltd - Archive - Terms of Use - Privacy Statement - Top

Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655