RE: $$Excel-Macros$$ Extract only from number from a text string

2010-08-24 Thread Chandra Gupt Kumar
Please follow the link. http://www.ozgrid.com/VBA/ExtractNum.htm Hope it serve the purpose. Regards, C.G.Kumar From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Monday, August 23, 2010 5:23 PM To:

RE: $$Excel-Macros$$ Rupee symbol on PC

2010-08-23 Thread Chandra Gupt Kumar
Its rocking. Regards, C.G.Kumar -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of viju mobile Sent: Monday, August 23, 2010 3:30 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Rupee symbol on PC Just use

RE: $$Excel-Macros$$ Problem New1

2010-08-21 Thread Chandra Gupt Kumar
Could you please elaborate the problem so that I may suggest a solution. Regards, C.G.Kumar -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of hemant shah Sent: Thursday, August 19, 2010 10:54 PM To: excel-macros@googlegroups.com

RE: $$Excel-Macros$$ sending e mail based on data in column in excel

2010-08-21 Thread Chandra Gupt Kumar
http://akoul.blogspot.com/ On Sat, Aug 21, 2010 at 10:31 AM, Chandra Gupt Kumar kumar.bemlmum...@gmail.com wrote: Could you please share how it is possible. Regards, C.G.Kumar From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Vasant Sent

$$Excel-Macros$$ sending e mail based on data in column in excel

2010-08-20 Thread Chandra Gupt Kumar
Dear All, My requirements are as follows; 1. Based on date of birth (Col D), mail to be sent on particular day to respective office for good wishes. 2. Based on date of joining , congratulation mail to be sent if the concerned completes 5,10,15,20,25,35,40 years of service.

RE: $$Excel-Macros$$ sending e mail based on data in column in excel

2010-08-20 Thread Chandra Gupt Kumar
based on data in column in excel Yes, it is possible to do Regards Vasant On 8/20/10, Chandra Gupt Kumar kumar.bemlmum...@gmail.com wrote: Dear All, My requirements are as follows; 1. Based on date of birth (Col D), mail to be sent on particular day to respective

RE: $$Excel-Macros$$ Etracting sales data as per desired criteria

2010-08-19 Thread Chandra Gupt Kumar
Please find attached solution. Regards, C.G.Kumar From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Kal xcel Sent: Wednesday, August 18, 2010 6:49 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Etracting sales data as per desired

RE: $$Excel-Macros$$ Pdf of Excel Macro

2010-07-15 Thread Chandra Gupt Kumar
Thanks Neil . Regards, C.G.Kumar AMW-2 From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of neil johnson Sent: Thursday, July 15, 2010 10:22 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Pdf of Excel Macro Hi Everyone, Please

RE: $$Excel-Macros$$ Finding a cell based on multiple criteria typed into cells

2010-07-14 Thread Chandra Gupt Kumar
Could you please attach sample sheet. Regards, C.G.Kumar AMW-2 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Sach1810 Sent: Wednesday, July 14, 2010 3:12 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Finding a cell

RE: $$Excel-Macros$$ Outlook Problem

2010-07-14 Thread Chandra Gupt Kumar
Yes. You can schedule the time of Message. First go to message option and then select the delivery option. Enter the date and time after which you want the message to be sent and save. The message will be sent after that time and provided your outlook is connected. Regards, C.G.Kumar

RE: $$Excel-Macros$$ Exrtact only numbers.

2010-07-02 Thread Chandra Gupt Kumar
Could not understand the objective. Regards, C.G.Kumar From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of lucky singh Sent: Tuesday, June 29, 2010 3:36 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Exrtact only numbers.

RE: $$Excel-Macros$$ Automatic Detail Summary

2010-06-02 Thread Chandra Gupt Kumar
If you have not received any solution yet, I would like to see the Sample data worksheet. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of SLF Sent: Monday, May 31, 2010 10:45 AM To: MS EXCEL AND VBA MACROS Subject:

RE: $$Excel-Macros$$ PAID LIST TRACER

2010-06-02 Thread Chandra Gupt Kumar
Kindly attach the worksheet. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of siva Sent: Friday, May 28, 2010 3:38 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ PAID LIST TRACER Dear Team, Please help me . I HAVE LAST

RE: $$Excel-Macros$$ Require help on a condition

2009-12-09 Thread Chandra Gupt Kumar
Dear Pooja Jee, Hope the solution provided by Dave serves the purpose. Regards, C.G.Kumar From: Dave Bonallack [mailto:davebonall...@hotmail.com] Sent: Friday, November 20, 2009 9:57 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Require help on a condition Hi

Re: $$Excel-Macros$$ Plz needful request

2009-11-18 Thread Chandra Gupt Kumar
PLZ USE V LOOKUP... On Wed, Nov 18, 2009 at 12:48 PM, Anil Saxena anilsaxena170...@gmail.comwrote: Hi All Plz suggest me how to use formula like these e. g. when i written any names automatically put value. Anil 100 Saxena 90 Guni 80 Sonu 70 Yash 60 Thakur 50 Mathur 40 --

Re: $$Excel-Macros$$ Change date format

2009-11-16 Thread Chandra Gupt Kumar
Just run the macro or press ctrl+g,it will do the needful you required. Regards, C.G.kumar On Mon, Nov 16, 2009 at 1:23 PM, Nandkumar kakvipure nandkumar.hindust...@gmail.com wrote: Hello Pls change the date format and tell me solution me manually nahi karsakta because 4500 customer same

Re: $$Excel-Macros$$ Re: Need a function or formula

2009-11-14 Thread Chandra Gupt Kumar
be. I'm attaching the complete sheet where I've tried it with more data. Hope you will again resolve this. Best Regards Pooja Sharma On Wed, Nov 4, 2009 at 1:05 AM, Pooja Sharma vatspoojav...@gmail.comwrote: -- Forwarded message -- From: Chandra Gupt Kumar kumar.bemlmum

$$Excel-Macros$$ Re: Need a function or formula

2009-11-02 Thread Chandra Gupt Kumar
Dear Pooja Jee, Attached the solution. Hope it serves the purpose. Regards, Kumar _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Hemant Hegde Sent: Sunday, November 01, 2009 11:49 AM To: excel-macros@googlegroups.com Subject:

$$Excel-Macros$$ Re: Need a function or formula

2009-11-02 Thread Chandra Gupt Kumar
Hi Deepak, You have provide good solution but when I drag the list it shows #NAME? . Further you have used .xlfn in your formulae , may you please tell what it is exactly and what it does. Regards, Kumar _ From: excel-macros@googlegroups.com

$$Excel-Macros$$ Re: Need a function or formula

2009-11-02 Thread Chandra Gupt Kumar
. Regards, Pooja On Mon, Nov 2, 2009 at 1:05 PM, Chandra Gupt Kumar kumar.bemlmum...@gmail.com wrote: Dear Pooja Jee, Attached the solution. Hope it serves the purpose. Regards, Kumar _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Hemant

$$Excel-Macros$$ Re: Help with user defined function

2009-11-01 Thread Chandra Gupt Kumar
Could you please attach one example of using the function i.e. left lookup function using the user defined function. Regards, C.G.Kumar _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Paul Schreiner Sent: Thursday, October 29, 2009

$$Excel-Macros$$ Happy Deepawali...

2009-10-16 Thread Chandra Gupt Kumar
♫ “Let this diwali burn all your bad times and enter you in good times” Wish you your family very happy joyful Deepawali... Regards, C.G.Kumar --~--~-~--~~~---~--~~ -- Some

$$Excel-Macros$$ Re: Write numbers in word

2009-10-05 Thread Chandra Gupt Kumar
Dear Dilip, I am not as good as you are. So, could you pls modify the Macro to suite Indian Curreny i.e. Rupees (Rs) and Paisa. Thanks On Sun, Oct 4, 2009 at 4:58 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Zaheer, Just answered this one a while ago. Check out and let me know if you

$$Excel-Macros$$ Re: When some data is filtered how to find unique values in excel

2009-09-29 Thread Chandra Gupt Kumar
Used Find option. On Tue, Sep 29, 2009 at 10:40 AM, Vikas Agarwal vikas@gmail.com wrote: Dear All, Need a small help. Is there a way to find unique values in excel when some data is filtered. Eg: There are 1-100 rows in a particular sheet If the filter contains some 20 odd rows

$$Excel-Macros$$ Computation of Tax payment Tax Code Wise.

2009-09-27 Thread Chandra Gupt Kumar
Dear Member, Monthly i take report of Sales for the previous months with respect to which Sales Tax is payable from our database. It gives in the format attached.Since, for filling of return, i require the sales tax payable tax rate wise, i have to mannualy insert a column and sort it first by CST

$$Excel-Macros$$ Re: Pivot Table on Date should show the result on Manth Basis

2009-09-24 Thread Chandra Gupt Kumar
Dear S.Deshpande, Saw the excel file but couldn't able to understand how you did it. Could you plz explain ? Regards, Kumar _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Swanand Deshpande Sent: Thursday, September 24, 2009

$$Excel-Macros$$ Re: Fwd: Name Matching In Excel

2009-09-24 Thread Chandra Gupt Kumar
Dear Sonal, I am afraid that the macro you are looking for may not be possible since name to be matched should be identical. If you find some solution, please let me know also. Regards, Kumar _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]

$$Excel-Macros$$ Re: Help Needed for Debit Credit entries

2009-09-24 Thread Chandra Gupt Kumar
Dear Dilip, You provided good answer . I have two 1. 1st possible solution based on Identifying the rowsin earlier problem '' leaves the first data matched as it is. 2. Could you tell how to do this in case I have two columns on named Dr and other named Cr. Both Columns have matching