Re: $$Excel-Macros$$ Re: Help required for Match DATA

2015-03-17 Thread Ashu k
Ok Sir, I am trying. Regards Ashu Kenith -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread title

Re: $$Excel-Macros$$ Re: Help required for Match DATA

2015-03-17 Thread Ashu k
Dear Mandeep Sir, All are enabled. PFA the attachment. Please provide Support. Regards Ashu Kenith -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULE

Re: $$Excel-Macros$$ Re: Help required for Match DATA

2015-03-16 Thread Mandeep baluja
in this attachment did you enabled this library in refrences go to vba editior enalble these library and then go to sheet1 and click the button send mails . microsoft outlook 14.0 object library ole auotmation microsoft excel 14.0 object library visual basic for applications microsoft forms 2.

Re: $$Excel-Macros$$ Re: Help required for Match DATA

2015-03-16 Thread Ashu k
Dear Mandeep Sir, Query is still pending from last 2 months. Last time you said that, you will send the answer shortly. Revert awaited from your side. Please help. Regards Ashu kenith. On 1/15/15, Ashu k wrote: Dear Mandeep Sir, Please Help on the same issue. Can i explain again my query. P

Re: $$Excel-Macros$$ Re: Help required for Match DATA

2015-01-16 Thread Ashu k
Dear Mandeep Sir, Please help. kindly send the macro. Regards Ashu Kenith. On Thu, Jan 15, 2015 at 6:41 PM, Ashu k wrote: > Dear Mandeep Sir, > > Please Help on the same issue. Can i explain again my query. > > Please help sir. > > Regards > Ashu Kenith > > On Thu, Jan 15, 2015 at 12:30 PM, A

Re: $$Excel-Macros$$ Re: Help required for Match DATA

2015-01-15 Thread Ashu k
Dear Mandeep Sir, Thanks a lot for your help. I don't have an facebook account. So, request you to please share the macro when you have time. Thanks for your help and kind support. Regards Ashu Kenith On Thu, Jan 15, 2015 at 9:33 PM, Mandeep Baluja wrote: > https://m.facebook.com/VBAEXCELSQL

Re: $$Excel-Macros$$ Re: Help required for Match DATA

2015-01-15 Thread Mandeep Baluja
https://m.facebook.com/VBAEXCELSQL?__tn__=C This is my page i have posted your macro on this blog top post is yours, Copy the same and run in your sheet. Sorry i forgot to send you the sheet.will send the same as i will be in office. Regards, Mandeep -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

Re: $$Excel-Macros$$ Re: Help required for Match DATA

2015-01-15 Thread Ashu k
Dear Mandeep Sir, Please Help on the same issue. Can i explain again my query. Please help sir. Regards Ashu Kenith On Thu, Jan 15, 2015 at 12:30 PM, Ashu k wrote: > Dear Mandeep Sir, > > Please help. > > Regards > Ashu Kenith. > > > On Tue, Jan 13, 2015 at 6:37 PM, Ashu k wrote: > >> Dear M

Re: $$Excel-Macros$$ Re: Help required for Match DATA

2015-01-14 Thread Ashu k
Dear Mandeep Sir, Please help. Regards Ashu Kenith. On Tue, Jan 13, 2015 at 6:37 PM, Ashu k wrote: > Dear Mandeep Sir, > > Thanks a lot for your help. > > one more help required. > > If the Merchant ID is same then paste the data (Order No., Item ID, Item > Name, RTO Date) on mail body which w

Re: $$Excel-Macros$$ Re: Help required for Match DATA

2015-01-13 Thread Ashu k
Dear Mandeep Sir, Thanks a lot for your help. one more help required. If the Merchant ID is same then paste the data (Order No., Item ID, Item Name, RTO Date) on mail body which was belongs to Same Merchant ID. Example : - Merchant ID is 12345 and 10 orders is placed by this merchant, then pas

Re: $$Excel-Macros$$ Re: Help required for Match DATA

2015-01-13 Thread Ashu k
Dear Mandeep Sir, Please Help. Regards Ashu Kenith. On Wed, Jan 7, 2015 at 4:18 PM, Ashu k wrote: > Dear Mandeep Sir, > > > Solution was perfect. But i want Paste the data in Mail body. > > Please check below sample Email :- > > > Dear Business Partner, > > > > This is to inform you that as p

Re: $$Excel-Macros$$ Re: Help required for Match DATA

2015-01-08 Thread Ashu k
Dear Mandeep Sir, Please Help!! Thanks Ashu Kenith. On Wed, Jan 7, 2015 at 4:18 PM, Ashu k wrote: > Dear Mandeep Sir, > > > Solution was perfect. But i want Paste the data in Mail body. > > Please check below sample Email :- > > > Dear Business Partner, > > > > This is to inform you that

Re: $$Excel-Macros$$ Re: Help required for Match DATA

2015-01-07 Thread Ashu k
Dear Mandeep Sir, Solution was perfect. But i want Paste the data in Mail body. Please check below sample Email :- Dear Business Partner, This is to inform you that as per our logistic partner report you have received RTO shipments with details as follow: *Order No* *Item ID* *Item Name

Re: $$Excel-Macros$$ Re: Help required for Match DATA

2015-01-07 Thread Ashu k
Dear Mandeep Sir, I don't want to send mail with attachment. I want send different mail to different customers according to the merchant ID. Subject and message body should be changed automatically with all the details (order no., rto date, item name, item id) when i punch the merchant id,order n

Re: $$Excel-Macros$$ Re: Help required for Match DATA

2015-01-07 Thread Ashu k
Dear Anil Sir, Thanks for your reply. But, i dont want to send mail with attachment. I want send different mail to different customers according to the merchant ID. Subject and message body should be changed automatically with all the details (order no., rto date, item name, item id) when i punch

Re: $$Excel-Macros$$ Re: Help required for Match DATA

2015-01-07 Thread Anil Gawli
Dear Mr. Ashu, Pls find attached as per you requirement. P.S pls change the address of the attachment as you req. .Add ("T:\Commercial\Common\Shailendra\Data" & Format(Now(), "mm-dd-yy") & ".xls") Warm regards, Gawli Anil. On Wed, Jan 7, 2015 at 1:24 PM, Ashu k wrote: > Dear Mandeep Sir, > >

Re: $$Excel-Macros$$ Re: Help required for Match DATA

2015-01-06 Thread Ashu k
Dear Mandeep Sir, PLease help. I want send mail to the customers. Example is attached. Thanks Ashu Kenith -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM

Re: $$Excel-Macros$$ Re: Help required for Match DATA

2015-01-06 Thread Ashu k
Dear Paul Sir, Thanks for your help and explaining me.. Dear Mandeep Sir, Thanks a lot for your help, Please check the attached sheet. Result was not showing in Last cell. Please help. Thanks Ashu Kenith. On Wed, Jan 7, 2015 at 10:21 AM, Mandeep Baluja wrote: > Hey Ashu, > > > Check this sh

Re: $$Excel-Macros$$ Re: Help required for Match DATA

2014-12-22 Thread Ashu k
Dear Mandeep Sir, It gives NA# again. Kindly run macro and See the result in Cell C1 and C12. Sheet attached. Thanks Ashu Kenith On Tue, Dec 23, 2014 at 10:52 AM, Mandeep Baluja wrote: > Now this macro works for 3 lakh rows you can increase the range as per > your convenience. > > Regards, >

Re: $$Excel-Macros$$ Re: Help required for Match DATA

2014-12-19 Thread Ashu k
Dear Mandeep Sir, It's not working. Thanks Ashu Kenith. On Thu, Dec 18, 2014 at 8:00 PM, Ashu k wrote: > > Dear Mandeep Sir, > > The code which is provided by you is not working properly. It's giving NA# > in sheet 2. > > Formula is working fine for me which is provided by Ashish Sir & Vaibhav

Re: $$Excel-Macros$$ Re: Help required for Match DATA

2014-12-18 Thread Ashu k
Dear Mandeep Sir, The code which is provided by you is not working properly. It's giving NA# in sheet 2. Formula is working fine for me which is provided by Ashish Sir & Vaibhav Sir. Kindly check the output and Please Help me. Sheet attached. Thanks Ashu Kenith On Thu, Dec 18, 2014 at 12:42 P

Re: $$Excel-Macros$$ Re: Help required for Match DATA

2014-12-17 Thread Ashu k
Dear Sir, Thank you very much. Thanks Ashu Kenith On Thu, Dec 18, 2014 at 10:56 AM, Mandeep Baluja wrote: > > check this out. > > Regards, > Mandeep Baluja > LearningZmyPassion > https://www.linkedin.com/profile/view?id=312532939 > https://www.facebook.com/VBAEXCELSQL?ref=hl > > On Wednesday,