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?
RagDyeR - 11 Jan 2006 16:52 GMT
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?

Signature
Regards,
RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------
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?
Don Guillett - 11 Jan 2006 16:52 GMT
right click sheet tab>view code>insert this>modify a10 to your cell>SAVE
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

Signature
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
>
> 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?
ED - 11 Jan 2006 21:10 GMT
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?
> 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?
Don Guillett - 11 Jan 2006 21:44 GMT
Why not just qualify Rag's offering with an IF
or
modify mine
Private Sub Worksheet_Change(ByVal Target As Range)
'If Target.Address <> "$A$10" Then Exit Sub
If Target.Column <> 1 Then Exit Sub
Target.Offset(, 1) = Target.Offset(-1, 1) + Target
End Sub

Signature
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
>I guess I should explain myself a bit better.
> Every month I enter the actual sales amount in Cell C13, then in Cell D13
[quoted text clipped - 10 lines]
>> sales
>> amount in the next cell. Is this possible?