Re: $$Excel-Macros$$ $$excel-$$ sumproduct not working in vba -reg.

2013-02-10 Thread karunanithi ramaswamy
End Sub I sent you only the part of the file. Thank u for your guidence. --R.Karunanithi. From: अनिल नारायण गवली To: excel-macros@googlegroups.com; era_...@yahoo.com Sent: Wednesday, February 6, 2013 11:41 AM Subject: Re: $$Excel-Macros$$ $$excel-$$ sumpro

Re: $$Excel-Macros$$ $$excel-$$ sumproduct not working in vba -reg.

2013-02-05 Thread अनिल नारायण गवली
Subject:* Re: $$Excel-Macros$$ $$excel-$$ sumproduct not working in vba > -reg. > > Dear Karunanithi, > > Pl find attached herewith required data. > > > Warm Regards, > Gawli Anil > > On Fri, Feb 1, 2013 at 4:56 PM, karunanithi ramaswamy > wrote: > > Sir,

Re: $$Excel-Macros$$ $$excel-$$ sumproduct not working in vba -reg.

2013-02-05 Thread karunanithi ramaswamy
@googlegroups.com; era_...@yahoo.com Sent: Tuesday, February 5, 2013 12:05 PM Subject: Re: $$Excel-Macros$$ $$excel-$$ sumproduct not working in vba -reg. Dear Karunanithi,   Pl find attached herewith required data.     Warm Regards, Gawli Anil On Fri, Feb 1, 2013 at 4:56 PM, karunanithi ramaswamy wrote

Re: $$Excel-Macros$$ $$excel-$$ sumproduct not working in vba -reg.

2013-02-04 Thread अनिल नारायण गवली
Dear Karunanithi, Pl find attached herewith required data. Warm Regards, Gawli Anil On Fri, Feb 1, 2013 at 4:56 PM, karunanithi ramaswamy wrote: > Sir, >I have data of Station and category in columns a and b. But I want > the report > in category wise as in columns h to k. When i use th

$$Excel-Macros$$ $$excel-$$ sumproduct not working in vba -reg.

2013-02-01 Thread karunanithi ramaswamy
Sir,    I have data of Station and category in columns a and b.  But  I want the report in category wise as in columns h to k.  When i use the sumproduct formula it works and it is not working in vba. Please guide how to modify the vba to get the desired result.(formula used is available in the