If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
adding number in next cell
Every month I have to change the sales amount in my worksheet. I would like this amount to be added automatically to the total for the year sales amount in the next cell. Is this possible? |
#2
|
|||
|
|||
adding number in next cell
Of course it's possible!
If you would like a suggested formula: =SUM($A$1:A1) Now, if this doesn't work for you, how would I know that, with all the information that you gave us? -- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "ED" wrote in message ... Every month I have to change the sales amount in my worksheet. I would like this amount to be added automatically to the total for the year sales amount in the next cell. Is this possible? |
#3
|
|||
|
|||
adding number in next cell
right click sheet tabview codeinsert thismodify a10 to your cellSAVE
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address "$A$10" Then Exit Sub Target.Offset(, 1) = Target.Offset(, 1) + Target End Sub -- Don Guillett SalesAid Software "ED" wrote in message ... Every month I have to change the sales amount in my worksheet. I would like this amount to be added automatically to the total for the year sales amount in the next cell. Is this possible? |
#4
|
|||
|
|||
adding number in next cell
I guess I should explain myself a bit better.
Every month I enter the actual sales amount in Cell C13, then in Cell D13 I enter the cummulative sales amount for the year (which I calculate manually). The following month I enter the new actual sales amount in Cell C13 and I add this amount to the previous cummulative sales amount from the previous month in Cell D13. Can D13 be updated automatically with a formula every time I enter a new amount in Cell C13? "ED" wrote: Every month I have to change the sales amount in my worksheet. I would like this amount to be added automatically to the total for the year sales amount in the next cell. Is this possible? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
adding 0's to the left side of a constant number cell | faisal alfadl | General Discussion | 1 | November 25th, 2005 05:07 PM |
Microsoft Access Limits (file size, table records, users) | Mike | General Discussion | 4 | November 4th, 2005 03:01 AM |
First Number in a Cell | Kelly O. | Worksheet Functions | 4 | August 14th, 2005 03:31 PM |
Number of objects | thomak | General Discussion | 3 | February 17th, 2005 11:58 AM |
Adding contents of one cell to a range of cells. | CLJinVA | Worksheet Functions | 1 | February 10th, 2005 10:19 PM |