$$Excel-Macros$$ Send mail from excel having specific text : little macro help!

2014-02-17 Thread Jitender Saini
Hi Friends, Need your help to modify this macro as i m new to VBA. I have a macro in which we can mail through excel sheet (having a specific text in last column and row). It's working perfect as i want but now i want to modify this according to my another need. This macro send the mail to

Re: $$Excel-Macros$$- Query

2014-02-17 Thread mrExcel4u
Hi Atul, PFA... Thanks regards, www.MrExcel4U.com http://mrexcel4u.blogspot.com/ On Mon, Feb 17, 2014 at 1:15 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi Team, Can some one help. Regards Atul On Wed, Feb 12, 2014 at 1:46 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi

RE: $$Excel-Macros$$ Repeat the Number Series based on the Vlookup Number

2014-02-17 Thread Ravinder
PFA...without helping col. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Swapnil Palande Sent: Monday, February 17, 2014 11:24 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Repeat the Number Series based on the Vlookup Number

Re: $$Excel-Macros$$ Send mail from excel having specific text : little macro help!

2014-02-17 Thread mrExcel4u
Hi Jatinder,, PFA Hope it will help you.not 100% but u take an idea about the same.. Thanks regards, www.MrExcel4U.com http://mrexcel4u.blogspot.com/ On Mon, Feb 17, 2014 at 3:09 PM, Jitender Saini jeetusain...@gmail.comwrote: Hi Friends, Need your help to modify this macro as i m

Re: $$Excel-Macros$$ Repeat the Number Series based on the Vlookup Number

2014-02-17 Thread Swapnil Palande
Hi, I think what Kathir want is to repeat Request ID as per value mentioned in column F. Regards, Swapnil. On Mon, Feb 17, 2014 at 3:56 PM, Ravinder ravindervbacli...@gmail.comwrote: PFA.without helping col... *From:* excel-macros@googlegroups.com [mailto:

$$Excel-Macros$$ Date Picker macro

2014-02-17 Thread Anil Bhange
Hi Friends, Can you please share me the macro of Date picker or any sample file which I can use in excel to input the date. I seared on net but unfortunately I don't have the Microsoft Monthview Control 6.0 (SP6) on my VBA. Please help. Regards, Anil Bhange IP - 800105 -- Are you

Re: $$Excel-Macros$$ Date Picker macro

2014-02-17 Thread Swapnil Palande
Hi Anil, PFA. Regards, Swapnil. On Mon, Feb 17, 2014 at 4:40 PM, Anil Bhange anil.bha...@tatacommunications.com wrote: Hi Friends, Can you please share me the macro of Date picker or any sample file which I can use in excel to input the date. I seared on net but unfortunately I

$$Excel-Macros$$ Values for Radio Buttons

2014-02-17 Thread SG
Hi experts Please help me with your effective solution. I’m working on a training template in which individual scores would be analyzed scores for all trainees comes in summary sheet. For this, in each individual sheet I have used radio buttons. What I need is for a parameter, if I click

Re: $$Excel-Macros$$ Values for Radio Buttons

2014-02-17 Thread Abhishek Jain
Something like this? On Mon, Feb 17, 2014 at 4:58 PM, SG sonal...@gmail.com wrote: Hi experts Please help me with your effective solution. I'm working on a training template in which individual scores would be analyzed scores for all trainees comes in summary sheet. For this, in each

Re: $$Excel-Macros$$ For one workbook to another workbook using VBA

2014-02-17 Thread Manjunath Narayanappa
Sir, Can you please help me out with it Thanks Manjunath On Mon, Feb 17, 2014 at 1:09 PM, Manjunath Narayanappa manjunath.n1...@gmail.com wrote: Yeah i want that one... Can we do for Employee id Thanks Manjunath On Mon, Feb 17, 2014 at 1:02 PM, mrExcel4u mr.exce...@gmail.com wrote:

Re: $$Excel-Macros$$ Values for Radio Buttons

2014-02-17 Thread SG
O yes. Thanku so much. I guess the idea behind its working is that you have unfreezed the linked cell in properties. Am i right sir?? On Monday, February 17, 2014 6:23:08 PM UTC+5:30, Abhi wrote: Something like this? On Mon, Feb 17, 2014 at 4:58 PM, SG sona...@gmail.com

Re: $$Excel-Macros$$ Values for Radio Buttons

2014-02-17 Thread Abhishek Jain
Not exactly! For Option Buttons to act individually, you need to keep them in a group. The box you are seeing around the 5 buttons is a Frame (came from same toolbox) and when the option buttons are inside a frame, they are grouped and work individually from others. Since there were 3 questions,

Re: $$Excel-Macros$$ Values for Radio Buttons

2014-02-17 Thread SG
okeyzzThanku so much for explanation. One more thing, i'm unable to find this group box in toolbox. Is this is the Microsoft Form 2.0 frame?? if yes, then how you have grouped these radio buttons in this box. Because on dragging this, we have to use frame object for option button in which

Re: $$Excel-Macros$$ Values for Radio Buttons

2014-02-17 Thread Abhishek Jain
It's from the same form control toolbox you have picked the option button from. Upon hovering the mouse pointer over the control, it says Group Box (Form Control). You pick the group box first, draw it to the size on sheet, then you put option buttons in there. After you have put all the buttons,

$$Excel-Macros$$ Re: Extract a non accrued interest rate from principal, total interest and number of payment periods.

2014-02-17 Thread Silviu Felician
Hi, Does anybody know something about this one? Thanks, Silviu -- 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

Re: $$Excel-Macros$$ mail merge with Cc options

2014-02-17 Thread Vijayendra Rao
Dear Ashish, Thanks for your consideration. I know basic mail merge, I need to connect the CC in email and change the subject line for each email. It has to pick from the attached excel file. Regards, Vijayendra 2014-02-15 19:54 GMT+05:30 ashish koul koul.ash...@gmail.com: can u share

Re: $$Excel-Macros$$ mail merge with Cc options

2014-02-17 Thread priti verma
HI Vijayendra, please find attach file. On Mon, Feb 17, 2014 at 7:56 AM, Vijayendra Rao vijayendrar...@gmail.comwrote: Dear Ashish, Thanks for your consideration. I know basic mail merge, I need to connect the CC in email and change the subject line for each email. It has to pick from

$$Excel-Macros$$ $$ Excel-Macros$$ How to create consolidated production log

2014-02-17 Thread Manjunath Narayanappa
Hi Experts, How to extract data from multiple workbooks to one single workbook. Thanks Manjunath -- 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