Re: $$Excel-Macros$$ how to seperate

2015-06-15 Thread jayaraj metta
Yours mostly Welcome Regards, Jayaraju Metta On Mon, Jun 15, 2015 at 11:36 AM, Kumar Bhanushali < kumar.bhanush...@pmcprojects.com> wrote: > > *Dear Jayaraj Bhai,* > > > > Thanks a Lot !!! > > > > > > *Regards, Kumar Bhanushali * > > >

Re: $$Excel-Macros$$ how to seperate

2015-06-14 Thread Kumar Bhanushali
Dear Jayaraj Bhai, Thanks a Lot !!! Regards, Kumar Bhanushali Re: $$Excel-Macros$$ how to seperate jayaraj metta to: excel-macros 13-06-15 05:26 PM Sent by: excel-macros@googlegroups.com Cc: kumar.bhanushali From: jayaraj metta To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ how to seperate

2015-06-13 Thread jayaraj metta
Hi Kumar, You can use below vba code to get contractor details simply by entering Contractor Unique No and the filtered details will be saved to respected contractor sheets. Sub AutofilterExample() Dim Criteria As Integer 'Enter "Contractor Unique No" to get respected contractor details C

Re: $$Excel-Macros$$ how to seperate

2015-06-13 Thread Ashish Bhalara
Hello Mr.Kumar You can get same output by pivot table, see the attached file. On Sat, Jun 13, 2015 at 3:37 PM, Kumar Bhanushali < kumar.bhanush...@pmcprojects.com> wrote: > > *Dear Sir,* > > I had attached a file which contains Daily Report sheet, I am updating > this sheet daily. This sheet cont

$$Excel-Macros$$ how to seperate

2015-06-13 Thread Kumar Bhanushali
Dear Sir, I had attached a file which contains Daily Report sheet, I am updating this sheet daily. This sheet contains 7 nos of contractor. >From this sheet, I have to separate data, contractor wise. Please help Regards, Kumar Bhanushali DISCLAIMER The information contained in this e-mail incl