Re: $$Excel-Macros$$ Re: Please help - How to export specific range by ID to other excel file.

2012-11-26 Thread Anoop K Sharma
Hi Natron, I can't see any attachment here. Well, I hope you can simply get a range in a variable as follows: dim myRange as range set myRange= Worksheets(index).Range(define_range) and then you can call this range anywhere. Regards, Anoop On Wed, Nov 21, 2012 at 6:42 PM, Natron

$$Excel-Macros$$ How to calculate Joining Date from a given job period!!!

2012-11-26 Thread MRafique Ujjan
Dear All Excel Experts: I am having a following problem. I am given only total working days of an employee like 2 years 5 months 13 days Now i am asked to calculate joining date of each employee. Therefore, i need your help in this regard I hope u will help me as this group helped me

Re: $$Excel-Macros$$ How to calculate Joining Date from a given job period!!!

2012-11-26 Thread vba
Hi Use combination of Eyear, Emonth Edate to get differential Year, Month date value. Hope it works since I have not tested. Sent on my BlackBerry® from Vodafone -Original Message- From: MRafique Ujjan imrafiqu...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 26 Nov 2012

Re: $$Excel-Macros$$ How to calculate Joining Date from a given job period!!!

2012-11-26 Thread vba
Kindly ignore previous email. Sent on my BlackBerry® from Vodafone -Original Message- From: v...@vabs.in Date: Mon, 26 Nov 2012 11:36:33 To: excel-macros@googlegroups.com Reply-To: v...@vabs.in Subject: Re: $$Excel-Macros$$ How to calculate Joining Date from a given job period!!! Hi

$$Excel-Macros$$ Modify Code to to send range

2012-11-26 Thread Hilary Lomotey
Hello Excel Gurus, in the attached file i have a vba code that sends email with attachments, what i need is a little code addition to the code to include adding any comments in the range eg G2:G30 to the code, so that anytime i include something in that range, it will be part of the email ,

$$Excel-Macros$$ Small Query

2012-11-26 Thread Kenil Gala
Hi, Pls help me solve my small doubt. I have written it in the file attached. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem,

Re: $$Excel-Macros$$ Small Query

2012-11-26 Thread ashish koul
E4= (7-WEEKDAY(D4,2))+D4 On Mon, Nov 26, 2012 at 10:18 PM, Kenil Gala keni...@yahoo.com wrote: Hi, Pls help me solve my small doubt. I have written it in the file attached. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use

Re: $$Excel-Macros$$ Small Query

2012-11-26 Thread Kenil Gala
Thank you Sir!! --- On Mon, 11/26/12, ashish koul koul.ash...@gmail.com wrote: From: ashish koul koul.ash...@gmail.com Subject: Re: $$Excel-Macros$$ Small Query To: excel-macros@googlegroups.com Date: Monday, November 26, 2012, 4:57 PM  E4=  (7-WEEKDAY(D4,2))+D4 On Mon, Nov 26, 2012 at

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2012-11-26 Thread Ayush Jain
CSk, start the new topic please Thanks. On Nov 25, 2012 10:01 PM, CSK charandeeps...@gmail.com wrote: hi sir my query is i have extract last five yrs data of two stocks and one index on one sheet and prepare line chart and insert four combo boxes 1) stock 1 2) stock 2 3) Index 4)time

Re: $$Excel-Macros$$ Dynamic calendar quiz : There is a prize for the winner.

2012-11-26 Thread Ayush Jain
Thanks Vinay Dear Group, only 6 days left for the quiz, give it a try and you will learn something new Looking forward to your active participation Thanks Best regards Ayush Jain Group manager On Nov 26, 2012 7:52 AM, VINAY GUPTA vinaygupta...@gmail.com wrote: Submitted. Regards, Vinay

$$Excel-Macros$$ Re: Please Open the Excel file

2012-11-26 Thread Natron
Breaking passwords is not allowed in this forum. Thanks. Natron -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code

$$Excel-Macros$$ Collect Data

2012-11-26 Thread LearnExcel
HI Team, I have three excel sheets, the first two sheets “one workbook” and two workbook” each update every day and on cell “B” I need the number next to 4 to be moved to the end of main work sheet? Can someone help me out here -- Join official Facebook page of this forum @