$$Excel-Macros$$ Re: Need some help on the attached file

2008-11-24 Thread Gaurav Kapoor
I did that but in the pivot I need the subtotal for all.Can you help me in that because I was not able to do it. Gaurav K On Sun, Nov 23, 2008 at 8:18 PM, sarfaraz ahmed <[EMAIL PROTECTED]> wrote: > Prasanna is right... Pivot will solve your problem > Regards, > sarfaraz Ahmed > http://findsarfa

$$Excel-Macros$$ Re: Need some help on the attached file

2008-11-23 Thread sarfaraz ahmed
Prasanna is right... Pivot will solve your problem Regards, sarfaraz Ahmed http://findsarfaraz.blogspot.com On Sat, Nov 22, 2008 at 6:05 PM, Prasanna <[EMAIL PROTECTED]> wrote: > > Why Don't you try Pivot Table It Should Do the trick. > > > > > > On Nov 21, 5:08 pm, "Gaurav Kapoor" <[EMAIL PROTEC

$$Excel-Macros$$ Re: Need some help on the attached file

2008-11-22 Thread Prasanna
Why Don't you try Pivot Table It Should Do the trick. On Nov 21, 5:08 pm, "Gaurav Kapoor" <[EMAIL PROTECTED]> wrote: > Hi People, > I was looking for some help on the attached file.I have the data on > sheet 1 and in sheet 2 I want the data to be compiled for every > person.It should have the