Re: $$Excel-Macros$$ Re: URGENT: Sum of 2 Lines replaced by 1

2010-08-05 Thread Angelo Spinola
t; > > > Regards - Dave. > > > > From: spinolaang...@gmail.com > > Date: Tue, 3 Aug 2010 10:37:22 +0100 > > Subject: Re: $$Excel-Macros$$ Re: URGENT: Sum of 2 Lines replaced by 1 > > To: excel-macros@googlegroups.com > > > > Does someone el

Re: $$Excel-Macros$$ Re: URGENT: Sum of 2 Lines replaced by 1

2010-08-05 Thread Kishan Reddy, K
d and run the macro. > > I've used Columns IS:IV as a work space. If you want to put data in these > columns, then we'd have to change the macro a little. > > Regards - Dave. > > From: spinolaang...@gmail.com > Date: Tue, 3 Aug 2010 10:37:22 +0100 > Subject: R

RE: $$Excel-Macros$$ Re: URGENT: Sum of 2 Lines replaced by 1

2010-08-04 Thread Dave Bonallack
e: $$Excel-Macros$$ Re: URGENT: Sum of 2 Lines replaced by 1 To: excel-macros@googlegroups.com Does someone else know how to do this please! 2010/8/3 Dave Bonallack Hi Angelo, The summing could be done with worksheet functions - probably SUMPRODUCT. But the deleting of lines has to be done by

Re: $$Excel-Macros$$ Re: URGENT: Sum of 2 Lines replaced by 1

2010-08-03 Thread Angelo Spinola
Does someone else know how to do this please! 2010/8/3 Dave Bonallack > Hi Angelo, > The summing could be done with worksheet functions - probably SUMPRODUCT. > But the deleting of lines has to be done by macro, so it makes sense to do > both by macro. I can't look at it straight away, but if n

RE: $$Excel-Macros$$ Re: URGENT: Sum of 2 Lines replaced by 1

2010-08-02 Thread Dave Bonallack
Hi Angelo, The summing could be done with worksheet functions - probably SUMPRODUCT. But the deleting of lines has to be done by macro, so it makes sense to do both by macro. I can't look at it straight away, but if no one else comes up with anything, I'll have a look later. Regards - Dave.