Re: $$Excel-Macros$$ To Set Dropdownlist in Chart

2011-11-13 Thread kurikkal padinjarappalla
Regards, > > Sam Mathai Chacko > > > On Sun, Nov 13, 2011 at 8:05 PM, dguillett1 wrote: > >> See attached >> >> Don Guillett >> SalesAid Software >> dguille...@gmail.com >> >> *From:* kurikkal padinjarappalla >> *Sent:* Sunday

$$Excel-Macros$$ To Set Dropdownlist in Chart

2011-11-13 Thread kurikkal padinjarappalla
Dear All, Could somebody help me by setting a drop down list for creating chart, as if I select a particular client name in drop down list it should appear the chart of that particular client. please find the attached sample sheet. Thanks for your valuable solutions. Regards, Kurikkal. -- FOR

Re: $$Excel-Macros$$ To send mail from excel.

2011-10-28 Thread kurikkal padinjarappalla
//msdn.microsoft.com/en-us/library/ff519602(v=office.11).aspx#odc_office_UseExcelObjectModeltoSendMailPart2_MailingRangeSelectionBody > > Regards, > > Sam > > > On Sat, Oct 29, 2011 at 2:27 AM, kurikkal padinjarappalla < > padinjarappa...@gmail.com> wrote: > >>

$$Excel-Macros$$ To send mail from excel.

2011-10-28 Thread kurikkal padinjarappalla
Can somebody help me on this. -- Forwarded message -- From: kurikkal padinjarappalla Date: Thu, Oct 27, 2011 at 11:35 PM Subject: $$Excel-Macros$$ Re: To send mail from excel. To: excel-macros@googlegroups.com Attachment... On Thu, Oct 27, 2011 at 11:34 PM

$$Excel-Macros$$ Re: To send mail from excel.

2011-10-27 Thread kurikkal padinjarappalla
Attachment... On Thu, Oct 27, 2011 at 11:34 PM, kurikkal padinjarappalla < padinjarappa...@gmail.com> wrote: > > Hi group, > > Hope somebody can help me out by modifying the macro of below attached > sheet which Mr. Ashish had posted earlier to send mai

$$Excel-Macros$$ To send mail from excel.

2011-10-27 Thread kurikkal padinjarappalla
Hi group, Hope somebody can help me out by modifying the macro of below attached sheet which Mr. Ashish had posted earlier to send mails from excel: My requirement is that the body column should be copied to the mail without changing its cell format like below, Hi Ashish, how r u And is it

Re: $$Excel-Macros$$ Solution Request

2011-10-13 Thread kurikkal padinjarappalla
Hi Ahmed, I think Mr.Guillet was correct,as if i am right one cell in excel can hold only 32,767 characters, if you have thousands of mail ids then it may exceed this limit. On Thu, Oct 13, 2011 at 12:34 AM, Ahmed Honest wrote: > Dear Mr. Chethan, > > Just a Lovely, Damm and Beyond imagination s

Re: $$Excel-Macros$$ UDF Function for conditoin formetting

2011-08-18 Thread kurikkal padinjarappalla
y u r asking to send mail personally to u. On Tue, Aug 16, 2011 at 7:31 PM, Excel VBASQL wrote: > I can do this email me at excelvba...@gmail.com > > > On Tue, Aug 16, 2011 at 11:02 AM, ICWAI Help wrote: > >> Please provide me UDF functino for below requirement >> >> example:) >> >> if the cell

$$Excel-Macros$$ Age Wise Report

2011-08-02 Thread kurikkal padinjarappalla
Dear Kurikkal, Look Attached it may help u *=IF(COUNTIF(C2:E2,"0")=3,B2,(B2-SUM(C2:E2)))* *Best Regards,* *Venkat* *Chennai* On Tue, Aug 2, 2011 at 5:52 PM, kurikkal padinjarappalla < padinjarappa...@gmail.com> wrote: > Dear Venkat, > > Thanks for your effort and reply

$$Excel-Macros$$ Age Wise Report

2011-08-02 Thread kurikkal padinjarappalla
Dears, Can somebody help me to create a formula to get a age wise report as mentioned in the attachment. Regards, Kurikkal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and lin

Re: $$Excel-Macros$$ To Generate a Code

2011-07-17 Thread kurikkal padinjarappalla
should be DMF002. Thanks again for your help. Regards, Kurikkal. On Sun, Jul 17, 2011 at 7:18 PM, Mahesh parab wrote: > Hi Kurikkal > > find attach > > Thanks > Mahesh > > > On Sun, Jul 17, 2011 at 4:59 PM, kurikkal padinjarappalla < > padinjarappa...@gmai

Re: $$Excel-Macros$$ Simple Code

2011-07-17 Thread kurikkal padinjarappalla
Dear Sharad, You can use MROUND function. =MROUND(23,10) On Sun, Jul 17, 2011 at 2:52 PM, sharad jain wrote: > Hi Guys, > > Can someone please send me a simple code for round off to nearest 10? (No > macro if possible.) > > For example, if I put 23 in A1, it should result in 20 in B1 and if I

$$Excel-Macros$$ To Generate a Code

2011-07-17 Thread kurikkal padinjarappalla
Dear Experts, Hope somebody could help me to solve the problem mentioned in the attached sheet. Thanks in advance. Regards, Kurikkal. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tri

Re: $$Excel-Macros$$ I want to learn VBA

2011-07-01 Thread kurikkal padinjarappalla
please attach it On Fri, Jul 1, 2011 at 10:43 AM, ankur wrote: > Dear friends > I m agree that , the sites you all recommended are very useful ,but > for a new user , the best way to learn VBA is getting a book dedicated > on vba...becoz they provide step wise and detailed concepts > there

Re: $$Excel-Macros$$ To Copy Paste Data

2011-06-07 Thread kurikkal padinjarappalla
("A1").End(xlDown).Row).Sort > key1:=Sheets("Detailed").Range("a:a"), order1:=xlAscending, Header:=xlYes > > > End Sub > > > On Wed, Jun 8, 2011 at 12:14 AM, kurikkal padinjarappalla < > padinjarappa...@gmail.com> wrote: > >> D

$$Excel-Macros$$ To Copy Paste Data

2011-06-07 Thread kurikkal padinjarappalla
Dear Experts, Is there a way that in the attached file after entering data in the sheets named 7th June, 8th June, 9th June etc, should be get copy and pasted in detailed sheet on date wise by activating any command button. Thanks in advance. Regards, Kurikkal. -- -

Re: $$Excel-Macros$$ Re: Report reconcile

2011-03-04 Thread kurikkal padinjarappalla
And also the can we show the amt in difference column itself instead of 'NA' if it is as not found in report also. Regards, Kurikkal. On Fri, Mar 4, 2011 at 6:59 PM, kurikkal padinjarappalla < padinjarappa...@gmail.com> wrote: > Dear Saurabh, > > Thank u very much!!

Fwd: $$Excel-Macros$$ To Reconcile Two Reports

2011-02-28 Thread kurikkal padinjarappalla
Can somebody help please -- Forwarded message -- From: kurikkal padinjarappalla Date: Mon, Feb 28, 2011 at 12:40 PM Subject: Re: $$Excel-Macros$$ To Reconcile Two Reports To: excel-macros@googlegroups.com Cc: Mahesh parab , ashish koul Dear Mahesh, Thanks for your reply, I

Re: $$Excel-Macros$$ To Reconcile Two Reports

2011-02-28 Thread kurikkal padinjarappalla
, Mahesh parab wrote: > Dear All > > find attach Add in which compare two worksheet as well sheets in two > workbook & display results > > On Sun, Feb 27, 2011 at 9:33 PM, ashish koul wrote: > >> >> try this >> >> >> >> On Sun, Feb 27

Re: $$Excel-Macros$$ To Reconcile Two Reports

2011-02-27 Thread kurikkal padinjarappalla
t; > try this > > > > On Sun, Feb 27, 2011 at 8:30 PM, kurikkal padinjarappalla < > padinjarappa...@gmail.com> wrote: > >> Dear All, >> >> Can somebody create a macro to compare two reports, like result gets in >> pivot table, only difference is

$$Excel-Macros$$ To Reconcile Two Reports

2011-02-27 Thread kurikkal padinjarappalla
Dear All, Can somebody create a macro to compare two reports, like result gets in pivot table, only difference is it should show a remark column also. Please find the attached sample. Thanks in advance. Kurikkal. -- -