Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

Veerendra PFA this is designed to send email every 30secs. You can change linez to send evry hours Cheers//Vabs On Tuesday, November 6, 2012 6:00:55 PM UTC+5:30, Vabz wrote: Hi Send file with your code. Rgds//Vabs On Tuesday, November 6, 2012 5:55:23 PM UTC+5:30, Jayaprakash S wrote: Hi

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

in the Pivot Value (explained with an example in my previous attachement) any possibility of helping me ?? Thanks in advance! Cheers JP. On Tue, Nov 6, 2012 at 6:00 PM, Vabz v...@vabs.in wrote: Hi Send file with your code. Rgds//Vabs On Tuesday, November 6, 2012 5:55:23 PM UTC+5:30, Jayaprakash S

$$Excel-Macros$$ Help Required on : Sending an Auto generated E-mail, If there is any Value in the Pivot

Dear Masters, Good evening... Could you kindly help me in sending an Auto generated e-mail Only when there is a value in the Pivot. Enclosed more info in the Excel sheet. Thanks in advance !!! JP -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards, Jayaprakash. S (JAYAPRAKASH. S

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub This wll sent email every ten minutes Rgds//vabs On Tuesday, November 6, 2012 5:00:01 PM UTC+5:30, Jayaprakash S wrote: Dear Vabs, Thank you very much for spending your valuable time on my

Re: $$Excel-Macros$$ Re: Data Filled every 15 Min.

Thanks so much Vabs for making your valuable time helping out me working fine !! cheers On Fri, Sep 21, 2012 at 11:20 AM, Vabz v...@vabs.in wrote: Hi Jayaprakash S, Your query was challenging for me hence i tried solving it.. Read Instruction sheet carefully before running macro

$$Excel-Macros$$ Data Filled every 15 Min.

Dear Excel Gurus, Would require your help in completing this task. Excel attached for reference. Thank you in advance. Regards, JP -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use

Re: $$Excel-Macros$$ Shor cut required to break the internal link within the same work book

that save time?? sub ddd activesheet.usedrange.value=activesheet.usedrange.value end sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com -Original Message- From: Jayaprakash S Sent: Thursday, August 09, 2012 7:26 AM To: excel-macros

$$Excel-Macros$$ Shor cut required to break the internal link within the same work book

Dear Experts... Good Noon.. Need your help per attached example. Thanks in advance. JP. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles,

Re: $$Excel-Macros$$ Shor cut required to break the internal link within the same work book

Excel Developer SalesAid Software dguille...@gmail.com -Original Message- From: Jayaprakash S Sent: Thursday, August 09, 2012 1:47 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Shor cut required to break the internal link within the same work book Dear Experts

$$Excel-Macros$$ Auto Filling of Color - Need Help

Dear Experts, Good Noon. Need help in auto filling of Colours to the shapes as well attached excel sheet for more information. Kindly Help advise. Thank you. JP. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already

Re: $$Excel-Macros$$ Auto Filling of Color - Need Help

ActiveSheet.Shapes(i - 1).Fill.ForeColor.RGB =Cells(i, d).Interior.Color Next i End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com -Original Message- From: Jayaprakash S Sent: Tuesday, August 07, 2012 4:00 AM To: excel-macros@googlegroups.com Subject

$$Excel-Macros$$ Text With Numbers : Replaced with Text

Dear Experts, Good Morning. I have a case where in Data is built in with Text (1 2 Digits, Eg: 1 Uttar Pradesh, 20 Jharkhan) and without text also (CSD, Nepal). I required help to replace Olny the Text. enclosed sample file. Please help. Thank you. JP. -- -- FORUM RULES (986+ members

Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

. On Fri, Jul 27, 2012 at 12:47 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear JP, Please use.. =SUBSTITUTE(UPPER(E7),CHAR(ROW(INDIRECT(48:58))),) On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash S bhat.jayaprak...@gmail.com wrote: Dear Experts, Good Morning. I have a case where

Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

wrote: Dear JP, I got my mistake..Just i am sending you correct answers. On Fri, Jul 27, 2012 at 1:02 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear JP, Formula is working fine.. Please see attached sheet. On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash S bhat.jayaprak

$$Excel-Macros$$ WHEN STATUS GETS CHANGED - SHOULD GET AN E-MAIL TO MY ID

Dear Experts, Greetings... I need your help advise as per the attached example sheet. Many Thanks. JP -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code

$$Excel-Macros$$ Date to be formatted in to Customised Format

Dear Experts, Good Morning... Need your Help in formatting the Given Date in to customised format per attachment... Thanks in Advance! JP. -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent,

Re: $$Excel-Macros$$ Date to be formatted in to Customised Format

,hh:mm:ss AM/PM) See attached sheet for reference. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, Jul 17, 2012 at 10:32 AM, Jayaprakash S bhat.jayaprak...@gmail.com wrote: Dear Experts, Good Morning... Need your Help in formatting

$$Excel-Macros$$ Text - Splitting - Help Required through Formula

Dear Masters, Greetings!! Could you please help me to split the Text thruough a Formula for the attached example... Thank you. JP. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help,

$$Excel-Macros$$ Grade Wise Max Total Required

Dear Experts, Please help to get the Grade wise Maxium total through formula for the enclosed data. Many Thanks JP. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem,

Re: $$Excel-Macros$$ Grade Wise Max Total Required

(IF($A$2:$A$18=A22,$C$2:$C$18,)) On Wed, Jul 4, 2012 at 11:11 AM, Jayaprakash S bhat.jayaprak...@gmail.com wrote: Dear Experts, Please help to get the Grade wise Maxium total through formula for the enclosed data. Many Thanks JP. -- FORUM RULES (986+ members already BANNED

Re: $$Excel-Macros$$ Rounding Numbers

Thanks Dear Noorain, superb !! =ROUND(MROUND(A1,0.4),0.5) - this formula also works :-) Mr. Sanjib - It is not working per my requirement - thank u for your effort.. cheers JP. On Wed, Feb 22, 2012 at 1:04 PM, Jayaprakash S bhat.jayaprak...@gmail.com wrote: Dear Experts, Good Noon. Need

Re: $$Excel-Macros$$ Rounding Numbers

noorain.ans...@gmail.com wrote: Dear JP, See attached sheet.. On Wed, Feb 22, 2012 at 1:04 PM, Jayaprakash S bhat.jayaprak...@gmail.com wrote: Dear Experts, Good Noon. Need help on rounding up of numbers based on the decimal through a formula... the criteria for roudning is : a) Less

$$Excel-Macros$$ Rounding Numbers

Dear Experts, Good Noon. Need help on rounding up of numbers based on the decimal through a formula... the criteria for roudning is : a) Less than or equal to 0.5 should get round down to preceeding multiple of Ten (10.1 to 10.5 should be rounded to 10) b) Greater than or equal to 0.6 should

$$Excel-Macros$$ Advanced Excel Formula's

Dear Noorain, Good Morning... First of all... i would like to Thank You for your timely help valuable Advise !!! Just a small suggetion... As previously mentioned by the members that most of us are un-familiar with these advanced formula's and finding it bit difficult to understand the

Re: $$Excel-Macros$$ Indirect Formula - Need Advise

-ansari.blogspot.com/ On Fri, Nov 11, 2011 at 2:32 PM, Jayaprakash S bhat.jayaprak...@gmail.com wrote: Dear Experts, To make a Summary, i'm using indirect formula and need your help advise to complete the same.. Here with enclosed the example along with the issue. thank you. Jp -- FORUM RULES

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards, Jayaprakash. S (JAYAPRAKASH. S.) Adaptability is the most desirable habit

Re: $$Excel-Macros$$ Re: Help on Indirect Formula

. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards, Jayaprakash. S (JAYAPRAKASH. S.) Adaptability is the most desirable habit for success - Swamy Vivekananda. This message is for the designated recipient only and may contain privileged, proprietary, or otherwise

$$Excel-Macros$$ Indirect Formula - Need Advise

Dear Experts, To make a Summary, i'm using indirect formula and need your help advise to complete the same.. Here with enclosed the example along with the issue. thank you. Jp -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread