You need to be logged in to your Sky Poker account above to post discussions and comments.
You might need to refresh your page afterwards.
Excel Help...
It’s no great secret that where Microsoft packages are concerned, Word is my bag whereas Excel frustrates me (ironic because I work in the financial industry and I have to use the latter every day).
Is there a way I can overtype 17* into a cell containing the number 10, hit enter/return, and have the value in the cell change to 27? I know that I can have a separate column which can do the addition for me, but can I eliminate that and simply do the sum in the one cell? I’m not sure if I’m explaining what I mean… another sad irony, because I’m a writer! 
Google has not been my friend on this matter.
*numbers used are for example purposes only.
Comments
there is a short answer and a long answer...
the short answer is, "no."
the long answer is, "nooooooooooooooooooo."
1 sheet with individual scores with a 2nd sheet that auto totals them up.
the best way to achieve this is to use two cells. cell a1 is the new number cell a2 is the running total. then you can copy paste special a1 and add values to a2.
to make things easier you can use a button and assign a macro for this action.
If you're not aware Slip did an excellent Main/Mini Learderboard last year and probably wants to simplify it for this year.
So it is about Poker
do you know you can sum through sheets, if Sheet1 is the front running total sheet and say for example sheets2-366 were daily results.
Cells in Sheet1 , e.g. c3 could be =SUM(Sheet2:Sheet366!c3)
a) you probably knew that
b) probably doesn't solve your problem
at least it might help someone on this new Excel worktips thread
If I understand you correctly, then the easiest way is......
Click on the cell with "10" in it & type =10+17 then hit the "Enter" button, the cell then becomes 27.
Any good?
It becomes slightly more complicated though if you already have a formula in that cell.
Usually I would use a column/cell for each number as below......
If Cell A1 value is 10 & Cell B1 value is 17 we can add our formula so cell C1 shows the total using the formula below.
Highlight Column C then type =A1+B1 and ENTER......
if cell A1 =10 & cell B1 =17 Cell C1 will now show the total as 27.
1. Open your Excel spreadsheet
2. On the sheet with your data in Right Click the sheet name (probably Sheet1) and click View Code
3. In the window that opens paste the following:
Option Explicit
Dim addValue As Variant
Sub Worksheet_SelectionChange(ByVal Target As Range)
If Selection.Count = 1 Then
If Not Intersect(Target, Range("D:D")) Is Nothing Then
addValue = InputBox("Enter a value to Add:")
ActiveCell.Value = ActiveCell.Value + addValue
End If
End If
End Sub
4. Close the Visual Basic window that you just pasted this code into (no need to save it)
5. Click on any value in Column D and it will ask you for a value
6. Enter a value and press enter
7. Magic happens
In the part above where it says Range("D:D") you can alter that to any column you choose.
if this is just a matter of retaining your formatting so you don't have formula column c = col a + col b, it could be done using a macro.
as an example, you could have your existing data in col a and enter the data to be added in col b. the macro would then add the two sets of numbers together, replace the values in column a with the new totals and remove the data from col b.