$$Excel-Macros$$ duplicating data
I have 2 excel worksheets, both are in different formats. Both will contain the same data but spread across different parts of the worksheets. if I have filled in the data for 1 worksheet, how can i automate this data to be filled into the other worksheet? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using "remove me" as the subject.
$$Excel-Macros$$ date filtering by number
I have a spreadsheet that lists, with start dates in column C. I would like to be able to automatically number the dates which fall within the same week example, if start date falls within this week, column D will be labelled as 1. if start date falls within next week, column D will be labelled as 2. if start date falls within 3rd week, column D will be labelled as 3 and so on... Can anyone clue me in as to how to do this? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ date filtering by number
I have a spreadsheet that lists, with start dates in column C. I would like to be able to automatically number the dates which fall within the same week example, if start date falls within this week, column D will be labelled as 1. if start date falls within next week, column D will be labelled as 2. if start date falls within 3rd week, column D will be labelled as 3 and so on... Can anyone clue me in as to how to do this? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ filtering dates within this week
I have a series of dates. How can i filter dates that are within this week? thanks --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ matching and finding data
hi, how do i match columnA in spreadsheetA with columnB in spreadsheetB to find the value in columnD of spreadsheetB ? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ importing a table in powerpoint to excel
how do i go about importing a table in powerpoint to excel? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ rota template
Anyone has a template which allows to plan rota of 20+ people operating 2 shifts? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: column chart
Hi, if you could merge the y axis for both sides and teach me how to do it in excel 2003 will solve my problem. Thanks venkatesh srinivas wrote: > Hi Lynn! > > Please let me know if the below mentioned file solves our problem > > > > > On 8/18/09, Lynn wrote: > > > > > > i have the following columns > > - dates > > - no. of boxes packed > > - no. of boxes to be packed. > > > > how do i do a column chart which compares the no. of boxes packed vs > > to be packed ? > > > > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ column chart
i have the following columns - dates - no. of boxes packed - no. of boxes to be packed. how do i do a column chart which compares the no. of boxes packed vs to be packed ? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ can't find project or library
encounter this error : can't find project or library when try to run a code which contains Calendar1.Value any help? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ synchronising data in 2 excel files
i have 2 identical excel files updated by 2 different people. How do I synchronise the data into 1 file? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Daniel -- calendar pop-up
any help?? On Jul 7, 8:55 pm, Lynn wrote: > error --> missing MS calendar control 8.0 > pls help > > Thanks > > On Jul 7, 3:45 am, y2 kx wrote: > > > > > Hello Mr.CA Narendra Ashara, > > Try this link very simple.. > > >http://sudhirsunil.blogspot.com/2009/01/excel-pop-up-calendar-add-in > > > <http://sudhirsunil.blogspot.com/2009/01/excel-pop-up-calendar-add-in>*Calender > > **is available in all workBooks.* > > > On Mon, Jul 6, 2009 at 9:59 PM, CA NARENDRA ASHARA > > wrote: > > > > HI Daniel, > > > > Excel file with date function attached by you is really nice. How do I > > > make > > > it available to every excel file i.e. I want to use it in all workbook. > > > > Kindly guide me. Thanks in advance. > > > > Thanks & Regards, > > > CA Narendra Ashara | M.Com., A.C.A. | > > > > -Original Message- > > > From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] > > > On Behalf Of Daniel > > > Sent: 05 July, 2009 9:35 PM > > > To: excel-macros@googlegroups.com > > > Subject: $$Excel-Macros$$ Re: calendar pop-up > > > > Look at the attached file. > > > Daniel > > > > > -Message d'origine- > > > > De : excel-macros@googlegroups.com [mailto:excel- > > > > mac...@googlegroups.com] De la part de Lynn Envoyé : dimanche 5 > > > > juillet 2009 17:56 À : MS EXCEL AND VBA MACROS Objet : [Norton > > > > AntiSpam] $$Excel-Macros$$ Re: calendar pop-up > > > > > I don't understand what you are trying to tell me. I don't the command > > > > "Date ?" either. > > > > > Could you further explain? > > > > > On Jul 4, 10:21 pm, "Daniel" wrote: > > > > > Did you have a look at my workbook. The command "Date ?" is added to > > > > the > > > > > cell right click menu when the file is opened. It is removed when > > > > > the > > > > file > > > > > closes. > > > > > > Daniel > > > > > > > -Message d'origine- > > > > > > De : excel-macros@googlegroups.com [mailto:excel- > > > > > > mac...@googlegroups.com] De la part de Lynn Envoyé : samedi 4 > > > > > > juillet 2009 14:25 À : MS EXCEL AND VBA MACROS Objet : [Norton > > > > > > AntiSpam] $$Excel-Macros$$ Re: calendar pop-up > > > > > > > this is not what I wanted. I do not want the calendar to be shown > > > > on > > > > > > the excel sheet. > > > > > > It should only pop-up when I click on the cell which I need to > > > > enter a > > > > > > date. > > > > > > Pls review this. thanks > > > > > > > On Jul 4, 2:52 am, Dilip Pandey wrote: > > > > > > > Hi Lynn, > > > > > > > > Calender control has been explained in the attached workbook. > > > > > > > Note:- Date will be inserted in the selected cell, which can be > > > > > > modified. > > > > > > > check up the code and you will understand the logic, It is quite > > > > > > simple. > > > > > > > Thanks, > > > > > > > -- > > > > > > > DILIP KUMAR PANDEY > > > > > > > MBA-HR,B COM(Hons.),BCA > > > > > > > Mobile: +91 9810929744 > > > > > > > dilipan...@gmail.com > > > > > > > dilipan...@yahoo.com > > > > > > > New Delhi - 110062 > > > > > > > > On Fri, Jul 3, 2009 at 9:35 PM, Lynn > > > > wrote: > > > > > > > > > How can I have a calendar pop-up box for me to make date > > > > selection > > > > > > > > when I click on a cell? > > > > > > > > Using Calender Control in Excel.xls > > > > > > > 31KViewDownload- Hide quoted text - > > > > > > > > - Show quoted text -- Hide quoted text - > > > > > > - Show quoted text -- Hide quoted text - > > > - Show quoted text -- Hide quoted text - > > - Show quoted text - --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: colour coding alternate weeks
are you there??? On Jul 20, 10:58 pm, Lynn wrote: > could you teach me how you came up with this formula? > thanks > > On Jul 20, 1:40 pm, Ashish Pradhan wrote: > > > > > Hello Lynn > > > In Conditional Formatting, you can use the formula (Please select the entire > > column or rows where you have the dates) > > > =MOD((1+INT(($A2-DATE(YEAR($A2+4-WEEKDAY($A2+6)),1,5) > > +WEEKDAY(DATE(YEAR($A2+4-WEEKDAY($A2+6)),1,3)))/7)),2)=0 > > > However, this formula is not exactly correct because Week 1 and Week 53 are > > odd numbers and therefore won't alternate. > > > If anyone can suggest a better formula, please help. > > > -- > > Ashish > > > “If you enter this world knowing you are loved and you leave this world > > knowing the same, then everything that happens in between can be dealt > > with.” - A Quote from National Geographic Channel > > > On 7/19/09, Lynn wrote: > > > > I am entering dates every week into a spreadsheet. How can I > > > automatically colour a date on week 1 as red and week 2 as green for > > > all alternate weeks?- Hide quoted text - > > > - Show quoted text -- Hide quoted text - > > - Show quoted text - --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: colour coding alternate weeks
could you teach me how you came up with this formula? thanks On Jul 20, 1:40 pm, Ashish Pradhan wrote: > Hello Lynn > > In Conditional Formatting, you can use the formula (Please select the entire > column or rows where you have the dates) > > =MOD((1+INT(($A2-DATE(YEAR($A2+4-WEEKDAY($A2+6)),1,5) > +WEEKDAY(DATE(YEAR($A2+4-WEEKDAY($A2+6)),1,3)))/7)),2)=0 > > However, this formula is not exactly correct because Week 1 and Week 53 are > odd numbers and therefore won't alternate. > > If anyone can suggest a better formula, please help. > > -- > Ashish > > “If you enter this world knowing you are loved and you leave this world > knowing the same, then everything that happens in between can be dealt > with.” - A Quote from National Geographic Channel > > On 7/19/09, Lynn wrote: > > > > > > > I am entering dates every week into a spreadsheet. How can I > > automatically colour a date on week 1 as red and week 2 as green for > > all alternate weeks?- Hide quoted text - > > - Show quoted text - --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ colour coding alternate weeks
I am entering dates every week into a spreadsheet. How can I automatically colour a date on week 1 as red and week 2 as green for all alternate weeks? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: You may not use references to other worksheets or workbooks for Conditional Formatting criteria.
Any help? Lynn wrote: > i am already using named ranges. > still does not work, something must have went wrong when i copy from 1 > workbook to this one?? > > On Jul 18, 11:32 pm, "Daniel" wrote: > > You can use named ranges to bypass the impossibility. However, keep in mind > > that, in order to use it, the "other" workbook has to be opened. > > HTH > > Daniel > > > > > > > > > -Original Message- > > > From: excel-macros@googlegroups.com [mailto:excel- > > > mac...@googlegroups.com] On Behalf Of Lynn > > > Sent: samedi 18 juillet 2009 15:48 > > > To: MS EXCEL AND VBA MACROS > > > Subject: $$Excel-Macros$$ You may not use references to other worksheets > > > or workbooks for Conditional Formatting criteria. > > > > > i have copied my worksheet to another workbook. while trying to perform > > > conditional formatting i got this error: > > > > > You may not use references to other worksheets or workbooks for > > > Conditional Formatting criteria. > > > > > how to fix this?- Hide quoted text - > > > > - Show quoted text - --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: You may not use references to other worksheets or workbooks for Conditional Formatting criteria.
i am already using named ranges. still does not work, something must have went wrong when i copy from 1 workbook to this one?? On Jul 18, 11:32 pm, "Daniel" wrote: > You can use named ranges to bypass the impossibility. However, keep in mind > that, in order to use it, the "other" workbook has to be opened. > HTH > Daniel > > > > > -Original Message- > > From: excel-macros@googlegroups.com [mailto:excel- > > mac...@googlegroups.com] On Behalf Of Lynn > > Sent: samedi 18 juillet 2009 15:48 > > To: MS EXCEL AND VBA MACROS > > Subject: $$Excel-Macros$$ You may not use references to other worksheets > > or workbooks for Conditional Formatting criteria. > > > i have copied my worksheet to another workbook. while trying to perform > > conditional formatting i got this error: > > > You may not use references to other worksheets or workbooks for > > Conditional Formatting criteria. > > > how to fix this?- Hide quoted text - > > - Show quoted text - --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ You may not use references to other worksheets or workbooks for Conditional Formatting criteria.
i have copied my worksheet to another workbook. while trying to perform conditional formatting i got this error: You may not use references to other worksheets or workbooks for Conditional Formatting criteria. how to fix this? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Calender Control
any idea why Calender Control cannot be clicked? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ attendance sheet
I need to mark attendance for a class running for 3 months. anyone an attendance sheet for 15 people where i can just check on each box if they are present. this should also have a pie chart where each person's participation is shown as a percentage to all --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: about VBA in MS project
any help? On Jul 2, 11:54 pm, Lynn wrote: > how can this be done in MS project? > > On Jul 1, 8:09 pm, Dilip Pandey wrote: > > > > > Hi, > > > Check the attached file. Overdue tasks/ projects will be highlighted > > automatically. > > > Thanks, > > -- > > DILIP KUMAR PANDEY > > MBA-HR,B COM(Hons.),BCA > > Mobile: +91 9810929744 > > dilipan...@gmail.com > > dilipan...@yahoo.com > > New Delhi - 110062 > > > On Mon, Jun 29, 2009 at 7:34 PM, wrote: > > > > Any help? > > > > -Original Message- > > > From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] > > > On Behalf Of Lynn > > > Sent: Sunday, June 28, 2009 2:40 PM > > > To: MS EXCEL AND VBA MACROS > > > Subject: $$Excel-Macros$$ about VBA in MS project > > > > Hi, > > > > I have not been successful in getting this from MS project group. > > > > I would like to write a vba code to highlight tasks that has been > > > overdued for 1 week. > > > > any help here? > > > > thanks in advance > > > > Send instant messages to your online friendshttp://au.messenger.yahoo.com > > > Highlight Overdue - by - DILipandey.xls > > 18KViewDownload- Hide quoted text - > > > - Show quoted text -- Hide quoted text - > > - Show quoted text - --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ error : can't find object or library
I got this error : can't find object or library whenever i try to enter some information into a cell. can someone advise how to get raid of it? thanks --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Daniel -- calendar pop-up
error --> missing MS calendar control 8.0 pls help Thanks On Jul 7, 3:45 am, y2 kx wrote: > Hello Mr.CA Narendra Ashara, > Try this link very simple.. > > http://sudhirsunil.blogspot.com/2009/01/excel-pop-up-calendar-add-in > > <http://sudhirsunil.blogspot.com/2009/01/excel-pop-up-calendar-add-in>*Calender > **is available in all workBooks.* > > On Mon, Jul 6, 2009 at 9:59 PM, CA NARENDRA ASHARA > wrote: > > > > > > > HI Daniel, > > > Excel file with date function attached by you is really nice. How do I make > > it available to every excel file i.e. I want to use it in all workbook. > > > Kindly guide me. Thanks in advance. > > > Thanks & Regards, > > CA Narendra Ashara | M.Com., A.C.A. | > > > -Original Message- > > From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] > > On Behalf Of Daniel > > Sent: 05 July, 2009 9:35 PM > > To: excel-macros@googlegroups.com > > Subject: $$Excel-Macros$$ Re: calendar pop-up > > > Look at the attached file. > > Daniel > > > > -Message d'origine- > > > De : excel-macros@googlegroups.com [mailto:excel- > > > mac...@googlegroups.com] De la part de Lynn Envoyé : dimanche 5 > > > juillet 2009 17:56 À : MS EXCEL AND VBA MACROS Objet : [Norton > > > AntiSpam] $$Excel-Macros$$ Re: calendar pop-up > > > > I don't understand what you are trying to tell me. I don't the command > > > "Date ?" either. > > > > Could you further explain? > > > > On Jul 4, 10:21 pm, "Daniel" wrote: > > > > Did you have a look at my workbook. The command "Date ?" is added to > > > the > > > > cell right click menu when the file is opened. It is removed when > > > > the > > > file > > > > closes. > > > > > Daniel > > > > > > -Message d'origine- > > > > > De : excel-macros@googlegroups.com [mailto:excel- > > > > > mac...@googlegroups.com] De la part de Lynn Envoyé : samedi 4 > > > > > juillet 2009 14:25 À : MS EXCEL AND VBA MACROS Objet : [Norton > > > > > AntiSpam] $$Excel-Macros$$ Re: calendar pop-up > > > > > > this is not what I wanted. I do not want the calendar to be shown > > > on > > > > > the excel sheet. > > > > > It should only pop-up when I click on the cell which I need to > > > enter a > > > > > date. > > > > > Pls review this. thanks > > > > > > On Jul 4, 2:52 am, Dilip Pandey wrote: > > > > > > Hi Lynn, > > > > > > > Calender control has been explained in the attached workbook. > > > > > > Note:- Date will be inserted in the selected cell, which can be > > > > > modified. > > > > > > check up the code and you will understand the logic, It is quite > > > > > simple. > > > > > > Thanks, > > > > > > -- > > > > > > DILIP KUMAR PANDEY > > > > > > MBA-HR,B COM(Hons.),BCA > > > > > > Mobile: +91 9810929744 > > > > > > dilipan...@gmail.com > > > > > > dilipan...@yahoo.com > > > > > > New Delhi - 110062 > > > > > > > On Fri, Jul 3, 2009 at 9:35 PM, Lynn > > > wrote: > > > > > > > > How can I have a calendar pop-up box for me to make date > > > selection > > > > > > > when I click on a cell? > > > > > > > Using Calender Control in Excel.xls > > > > > > 31KViewDownload- Hide quoted text - > > > > > > > - Show quoted text -- Hide quoted text - > > > > > - Show quoted text -- Hide quoted text - > > - Show quoted text - --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ macro to delete all labels
hi, anyone has a macro to delete all labels in a spreadsheet? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ timeline
how can i draw a monthly timeline in excel to visually tell the recipient where are we now --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: calendar pop-up
I don't understand what you are trying to tell me. I don't the command "Date ?" either. Could you further explain? On Jul 4, 10:21 pm, "Daniel" wrote: > Did you have a look at my workbook. The command "Date ?" is added to the > cell right click menu when the file is opened. It is removed when the file > closes. > > Daniel > > > > > -Message d'origine- > > De : excel-macros@googlegroups.com [mailto:excel- > > mac...@googlegroups.com] De la part de Lynn > > Envoyé : samedi 4 juillet 2009 14:25 > > À : MS EXCEL AND VBA MACROS > > Objet : [Norton AntiSpam] $$Excel-Macros$$ Re: calendar pop-up > > > this is not what I wanted. I do not want the calendar to be shown on > > the excel sheet. > > It should only pop-up when I click on the cell which I need to enter a > > date. > > Pls review this. thanks > > > On Jul 4, 2:52 am, Dilip Pandey wrote: > > > Hi Lynn, > > > > Calender control has been explained in the attached workbook. > > > Note:- Date will be inserted in the selected cell, which can be > > modified. > > > check up the code and you will understand the logic, It is quite > > simple. > > > Thanks, > > > -- > > > DILIP KUMAR PANDEY > > > MBA-HR,B COM(Hons.),BCA > > > Mobile: +91 9810929744 > > > dilipan...@gmail.com > > > dilipan...@yahoo.com > > > New Delhi - 110062 > > > > On Fri, Jul 3, 2009 at 9:35 PM, Lynn wrote: > > > > > How can I have a calendar pop-up box for me to make date selection > > > > when I click on a cell? > > > > Using Calender Control in Excel.xls > > > 31KViewDownload- Hide quoted text - > > > > - Show quoted text -- Hide quoted text - > > - Show quoted text - --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: calendar pop-up
this is not what I wanted. I do not want the calendar to be shown on the excel sheet. It should only pop-up when I click on the cell which I need to enter a date. Pls review this. thanks On Jul 4, 2:52 am, Dilip Pandey wrote: > Hi Lynn, > > Calender control has been explained in the attached workbook. > Note:- Date will be inserted in the selected cell, which can be modified. > check up the code and you will understand the logic, It is quite simple. > Thanks, > -- > DILIP KUMAR PANDEY > MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > > On Fri, Jul 3, 2009 at 9:35 PM, Lynn wrote: > > > How can I have a calendar pop-up box for me to make date selection > > when I click on a cell? > > > > Using Calender Control in Excel.xls > 31KViewDownload- Hide quoted text - > > - Show quoted text - --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ calendar pop-up
How can I have a calendar pop-up box for me to make date selection when I click on a cell? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: about VBA in MS project
how can this be done in MS project? On Jul 1, 8:09 pm, Dilip Pandey wrote: > Hi, > > Check the attached file. Overdue tasks/ projects will be highlighted > automatically. > > Thanks, > -- > DILIP KUMAR PANDEY > MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > > On Mon, Jun 29, 2009 at 7:34 PM, wrote: > > > Any help? > > > -Original Message- > > From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] > > On Behalf Of Lynn > > Sent: Sunday, June 28, 2009 2:40 PM > > To: MS EXCEL AND VBA MACROS > > Subject: $$Excel-Macros$$ about VBA in MS project > > > Hi, > > > I have not been successful in getting this from MS project group. > > > I would like to write a vba code to highlight tasks that has been > > overdued for 1 week. > > > any help here? > > > thanks in advance > > > Send instant messages to your online friendshttp://au.messenger.yahoo.com > > > > Highlight Overdue - by - DILipandey.xls > 18KViewDownload- Hide quoted text - > > - Show quoted text - --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ displaying an empty cell
I used to reference cells in our worksheets (e.g. =Sheet1!C6). if Sheet1!C6 is empty i will get a 0 in my cell. How can i get a blank cell if Sheet1!C6 is an empty cell? thanks --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ about VBA in MS project
Hi, I have not been successful in getting this from MS project group. I would like to write a vba code to highlight tasks that has been overdued for 1 week. any help here? thanks in advance --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---