Re: $$Excel-Macros$$ Date Format Query

2014-06-13 Thread Pramod Singh
Where have not applying this date format.. Can send u file with mark area Pramod On 14 Jun 2014 10:41, "Pravin Gunjal" wrote: > Dear Pramod, > > Thank you for your reply. But I found it is not giving result for all > cells. > Please do the needful. > > > On Thu, Jun 12, 2014 at 4:22 PM, Pra

Re: $$Excel-Macros$$ Date Format Query

2014-06-13 Thread Pravin Gunjal
Dear Pramod, Thank you for your reply. But I found it is not giving result for all cells. Please do the needful. On Thu, Jun 12, 2014 at 4:22 PM, Pramod Singh wrote: > Hi > Pravin Gunjal, > > PFA > > Hope This will fine for you.. > > > > > Warm Regards > > Pramod > > VBA Developer > > > O

Re: $$Excel-Macros$$ Macro Data entry by row and column search

2014-06-13 Thread Michael Kohl
*Paul, * *Thank you so much for the work you did. Clearly you have a lot of talent and experience since I have been digging through this for a few hours and I was only able to make minor modifications. So I figured I would ask you some more questions and save the time digging into this de

$$Excel-Macros$$ Urgent required .NET Developer - Redmond, WA

2014-06-13 Thread Gary .
*Please respond to gurjant.si...@damcosoft.com * *Position: .NET Developer Location: Redmond, WADuration: 6-12 Months* Job Description: The successful candidate will be responsible for maintaining and improving an existing data processing engine for warehousing audio and textual data samples.

Re: $$Excel-Macros$$ Re: Can We creat Auto Mailer In Excel.

2014-06-13 Thread Vaibhav Joshi
This one is whole mail body as required by you.. On Tue, May 20, 2014 at 5:07 PM, Vaibhav Joshi wrote: > Hi > > PFA.. > > You can change it to as per your need. > > Cheers!! > > > On Tue, May 20, 2014 at 4:33 PM, khagesh khera > wrote: > >> Dear Expert, >> >> I am working with an MNC & the dat

Re: $$Excel-Macros$$ Re:Date conversion

2014-06-13 Thread Mohd Sanusi Mohd Noor
Dear Ravinder, Thank you very much. It works well. Best regards Sanusi On 13 June 2014 17:30, Ravinder wrote: > Try below > =TEXT(DATE(RIGHT(B14,4),MID(B14,4,2),LEFT(B14,2)),"DD-MMM-YY") > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]

RE: $$Excel-Macros$$ Re:Date conversion

2014-06-13 Thread Ravinder
Try below =TEXT(DATE(RIGHT(B14,4),MID(B14,4,2),LEFT(B14,2)),"DD-MMM-YY") -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mohd Sanusi Mohd Noor Sent: Friday, June 13, 2014 2:56 PM To: excel-macros@googlegroups.com Subject: $$Excel-

Re: $$Excel-Macros$$ Need Help

2014-06-13 Thread Divaker Pandey
you can use pivot table option On Fri, Jun 13, 2014 at 1:23 AM, Imran Khan wrote: > Dear All, > > I need your help to summarize the sheet. I have attach the file as an > example. I am looking formula to summarize matching with T1A, T1R & T2 from > Data sheet. > > Please help me. > > I applogise