Re: $$Excel-Macros$$ how to get cumulative sum in a cell

2013-02-19 Thread David Grugeon
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

Re: $$Excel-Macros$$ how to get cumulative sum in a cell

2013-02-18 Thread 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:

Fwd: $$Excel-Macros$$ how to get cumulative sum in a cell

2013-02-18 Thread David Grugeon
Following message posted direct to Anton by mistake. It worked. Regards David Grugeon -- Forwarded message -- From: David Grugeon Date: 17 February 2013 07:16 Subject: Re: $$Excel-Macros$$ how to get cumulative sum in a cell To: anton Have a look at this link. The solution

Re: $$Excel-Macros$$ how to get cumulative sum in a cell

2013-02-16 Thread anton
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

Re: $$Excel-Macros$$ how to get cumulative sum in a cell

2013-02-16 Thread David Grugeon
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

Re: $$Excel-Macros$$ how to get cumulative sum in a cell

2013-02-15 Thread anton
(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 > >

Re: $$Excel-Macros$$ how to get cumulative sum in a cell

2013-02-15 Thread anton
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

Re: $$Excel-Macros$$ how to get cumulative sum in a cell

2010-06-26 Thread anton
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

RE: $$Excel-Macros$$ how to get cumulative sum in a cell

2010-06-25 Thread Dave Bonallack
) + 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

Re: $$Excel-Macros$$ how to get cumulative sum in a cell

2010-06-24 Thread anton
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.

RE: $$Excel-Macros$$ how to get cumulative sum in a cell

2010-06-24 Thread Dave Bonallack
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

Re: $$Excel-Macros$$ how to get cumulative sum in a cell

2010-06-24 Thread anton
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

Re: $$Excel-Macros$$ how to get cumulative sum in a cell

2010-06-24 Thread anton
do the accumulation automatically. > > If this suits your purpose, there are lots of us in the group who could help > you achieve this. > > Regards - Dave. > > > > > > > Date: Wed, 23 Jun 2010 11:22:58 -0700 > > Subject: $$Excel-Macros$$ how to get cumulative

RE: $$Excel-Macros$$ how to get cumulative sum in a cell

2010-06-23 Thread Dave Bonallack
achieve this. Regards - Dave. > Date: Wed, 23 Jun 2010 11:22:58 -0700 > Subject: $$Excel-Macros$$ how to get cumulative sum in a cell > From: a...@kwic.com > To: excel-macros@googlegroups.com > > Dear Group, > I am constructing a single entry accounting spreadsheet in excel. i

Re: $$Excel-Macros$$ how to get cumulative sum in a cell

2010-06-23 Thread Jagjeet Singh
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

$$Excel-Macros$$ how to get cumulative sum in a cell

2010-06-23 Thread anton
Dear Group, I am constructing a single entry accounting spreadsheet in excel. i would like to input numbers for, say grocery expenses, in a cell of fixed location. when I buy more groceries i would like to type in the new expense in the same cell so that the output of that cell is the cumulative to