et.Offset(0, 11) = Target.Offset(0, 11) + Target
>> If Range("A2").Value = "Dec" And Target.Column = 2 Then
>> Target.Offset(0, 12) = Target.Offset(0, 12) + Target
>> Target.Select
>> End Sub
>>
>> David Grugeon
e = "Nov" And Target.Column = 2 Then Target.Offset(0,
> 11) = Target.Offset(0, 11) + Target
> If Range("A2").Value = "Dec" And Target.Column = 2 Then Target.Offset(0,
> 12) = Target.Offset(0, 12) + Target
> Target.Select
> End Sub
>
> David Grugeon wrote:
ne to your code:
>>> Target.Select
>>> So the macro will now look like this:
>>>
>>> Private Sub Worksheet_Change(ByVal Target As Range)
>>> If Target.Column = 2 Then Target.Offset(0, 1) = Target.Offset(0, 1) +
>>> Target
>>> Target.Sele
rget As Range)
>> If Target.Column = 2 Then Target.Offset(0, 1) = Target.Offset(0, 1) +
>> Target
>> Target.Select
>> End Sub
>>
>> Regards - Dave.
>>
>>
>> > Date: Thu, 24 Jun 2010 10:25:48 -0700
>>
>> > Subject: Re: $$Excel-Macros$$ how to
(0, 1) +
> Target
> Target.Select
> End Sub
>
> Regards - Dave.
>
>
> > Date: Thu, 24 Jun 2010 10:25:48 -0700
> > Subject: Re: $$Excel-Macros$$ how to get cumulative sum in a cell
> > From: a...@kwic.com
> > To: excel-...@googlegroups.com
> >
t; > Date: Thu, 24 Jun 2010 03:36:37 -0700
> > Subject: Re: $$Excel-Macros$$ how to get cumulative sum in a cell
> > From: a...@kwic.com
> > To: excel-...@googlegroups.com
> >
> > Hi Dave,
> > Thanks very much for your reply. Yes this would be sufficien
sheet_Change(ByVal Target As Range)If Target.Column = 2 Then
> Target.Offset(0, 1) = Target.Offset(0, 1) + TargetTarget.SelectEnd Sub
> Regards - Dave.
>
>
>
>
>
> > Date: Thu, 24 Jun 2010 10:25:48 -0700
> > Subject: Re: $$Excel-Macros$$ how to get cumulative sum in
) + TargetTarget.SelectEnd Sub
Regards - Dave.
> Date: Thu, 24 Jun 2010 10:25:48 -0700
> Subject: Re: $$Excel-Macros$$ how to get cumulative sum in a cell
> From: a...@kwic.com
> To: excel-macros@googlegroups.com
>
> Hi Dave,
> your code works very well. it seems to work for text in col B w
r, but we could test for
> non-numeric input if needed.
> Regards - Dave.
>
>
>
>
>
> > Date: Thu, 24 Jun 2010 03:36:37 -0700
> > Subject: Re: $$Excel-Macros$$ how to get cumulative sum in a cell
> > From: a...@kwic.com
> > To: excel-macros@googlegroups.
atter, but we could test for
non-numeric input if needed.
Regards - Dave.
> Date: Thu, 24 Jun 2010 03:36:37 -0700
> Subject: Re: $$Excel-Macros$$ how to get cumulative sum in a cell
> From: a...@kwic.com
> To: excel-macros@googlegroups.com
>
> Hi Dave,
> Thanks very much for
Dear Jagjeet,
Thanks for your reply. It appears from your comment that two cells are
needed and Dave's suggestion will achieve this.
Best Regards,
anton
On Jun 24, 12:48 am, Jagjeet Singh wrote:
> Dear Anton
>
> Please send the sample sheet. as you have to input the values in two
> different cel
Hi Dave,
Thanks very much for your reply. Yes this would be sufficient. Your
suggestion that XL can monitor changes to A2 and store the cumulative
total in A3 would be great. I would have about 50 similar accounts
such as gas, books, donations, repairs etc.
Would you be able to construct this macro
Hi Anton,
XL can almost do what you want, which may be sufficient for you.
If you want to be able to enter your grocery expenditure always in the same
cell, XL can accumulate those entries in another cell using VBA.
For example, You may enter your grocery expenditure always into A2, but the
a
Dear Anton
Please send the sample sheet. as you have to input the values in two
different cells to get the accumulation.
You cannt overwrite the cell and expect a cumulative figure
Please elaborate and if possible send the worksheet.
Regards
Jagjeet Singh
On Wed, Jun 23, 2010 at 11:52 PM, ant
14 matches
Mail list logo
