$$Excel-Macros$$ hi thanks for the help
hi can you please give ma codes which will remove the unwated or_ at the end of emailds in attachment thanks ashish --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~--- example.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Re: How to create new file with name and content from excel
*Created a tool. *See attached file.. On Sun, Sep 6, 2009 at 11:10 PM, mykijune wrote: > > How can I create multiple new files using data from excel? For > example: > > A1=ProductName1 B2=Productdescription1 > A2=ProductName2 B2=Productdescription2 > > Etc.. > > To: > > productname1.txt (containing productdescription1) > productname2.txt (containing productdescription2) > > > in specified folder "products" for example. > Etc.. > > Thanks. > > > > -- Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~--- export.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Find the Number
Thanx man, u all ppls are just awesome. double thumbs up for u .. On Sun, Sep 6, 2009 at 2:43 PM, jonell wrote: > On Sep 5, 5:07 pm, Mahesh wrote: > > Dear Firends, > > > > need ur help here. > > > > i want to enter number in sheet 2 and want to match it in sheet 1 > > if the same number is not in the sheet 1 then it will find the nearest > > number either +1 or -1. > > > > Please check the attached sheet. > > > > -- > > With Love, > > Mahesh Bisht > > > > Book1.xlsx > > 15KViewDownload > > Hi Mahesh, > > I hope the attached file will help. > > Regards, > Jonell > > > > > -- With Love, Mahesh Bisht --~--~-~--~~~---~--~~ -- 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: Another milestone of the group : 6000 members
Dear Ayush and Ashish, Congratulations to both of you and thank you for creating this wonderful forum to learn excel from the masters in this group. Thanks Ashish On 9/6/09, Ayush wrote: > > Dear Members, > > Finally With all your support and good wishes we have completed 6000 > Members in our Google group.We have achieved this mark in very short > span of time.I hope this group reaches more milestones and help more & > more people around the world. > > Our Google group is a free service. Please let your friends and office > colleagues about this group. > > Here, I would like appreciate the sincere efforts of all time top 10 > posters for their remarkable help to group members from their subject > knowledge. They really deserve a big applause. > > On this occasion lets celebrate it again with lots of energy... > > You suggestions are most welcome again. > > All Cheers to U... > > Regards, > Ayush Jain > [Group Owner] > > > -- Ashish "The older we get, the more we needs people around us who knew us when we were young" -- Unknown --~--~-~--~~~---~--~~ -- 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: help plz
hi thanks i went through the site i am able to clean and trim but in below case i am not abe to find the solution ashish k...@gmail.com. result should be ashishk...@gmail.com koulashish @gmail.com...result should be koulash...@gmail.com koul.ashish @gmail.com result should be koul.ash...@gmail.com thanks ashish --~--~-~--~~~---~--~~ -- 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: How to create new file with name and content from excel
*Created a tool.**See attached file..* On Sun, Sep 6, 2009 at 11:10 PM, mykijune wrote: > > How can I create multiple new files using data from excel? For > example: > > A1=ProductName1 B2=Productdescription1 > A2=ProductName2 B2=Productdescription2 > > Etc.. > > To: > > productname1.txt (containing productdescription1) > productname2.txt (containing productdescription2) > > > in specified folder "products" for example. > Etc.. > > Thanks. > > > > -- Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~--- export.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ How to create new file with name and content from excel
How can I create multiple new files using data from excel? For example: A1=ProductName1 B2=Productdescription1 A2=ProductName2 B2=Productdescription2 Etc.. To: productname1.txt (containing productdescription1) productname2.txt (containing productdescription2) in specified folder "products" for example. Etc.. 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,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: help needed
hi daniel i tried your code its working perfectly thanks but wht in this situation in attached sheet i want to remove all non wanted charters at the end of email ids... Thanks Ashish --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~--- example.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Re: Puzzle #1 - Generate the Sample Pattern (VBA)
Thanks Ashish, but don't forget u will be sending more like this. correct? :) On Sun, Sep 6, 2009 at 4:15 PM, Ashish Jain <26may.1...@gmail.com> wrote: > > Hi Harmeet, > > That's fantastic. and good that you protected the code. I want > everyone to try, so that their logic and vba skills can be sharpened. > Well Done Harry. > > > -- > Regards > Ashish Jain > (Excel Macros - Google Group Manager) > http://www.excelitems.com > (Developer of OpenXL) > http://www.openexcel.com > > Excel,VBA,VSTO Trainer > +91..40.48.43 > -- > On Sep 6, 12:55 pm, Harmeet Singh wrote: > > *Hey **Ashish**,**Thanks a lot for this interesting puzzle.* > > *Looking forward for more innovative puzzles.* > > * > > * > > *Solution is attachedLet me know if I have done it > > appropriately.* > > > > > > > > On Sun, Sep 6, 2009 at 10:06 AM, Ashish Jain <26may.1...@gmail.com> > wrote: > > > Hi All, > > > > > This is challenge for all excel users. Solve these puzzles and sharpen > your > > > excel acumen. So, here goes the first puzzle of "Excel Macros Google > Group" > > > in attached file. > > > > > > -- > > > Regards > > > Ashish Jain > > > (Excel Macros - Google Group Manager) > > >http://www.excelitems.com > > > (Developer of OpenXL) > > >http://www.openexcel.com > > > > > Excel,VBA,VSTO Trainer > > > +91..40.48.43 > > > > -- > > > > -- > > Thanks & Regards, > > > > Harmeet Singh > > > > Sent via BlackBerry Wireless > > > > Puzzle #1.xls > > 109KViewDownload > > > -- Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless --~--~-~--~~~---~--~~ -- 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: help needed
More precisely : Sub test() Dim c As Range For Each c In Selection If c.Value <> "" Then c.Value = Application.Clean(c.Value) c.Value = Application.Trim(c.Value) c.Value = Application.Substitute(c.Value, " ", "") End If Next c End Sub Daniel From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ashish koul Sent: dimanche 6 septembre 2009 16:23 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ help needed hi i need a code or macro who will clean unwanted spaces and character in the colums conatings email ids like ashish k...@gmail.com. result should be ashishk...@gmail.com koulashish @gmail.com...result should be koulash...@gmail.com koul.ashish @gmail.com result should be koul.ash...@gmail.com thanks ashish --~--~-~--~~~---~--~~ -- 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: help needed
Hi. Select range and execute the following macro : Sub test() Dim c As Range For Each c In Selection If c.Value <> "" Then c.Value = Application.Clean(c.Value) c.Value = Application.Trim(c.Value) End If Next c End Sub Best regards. Daniel From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ashish koul Sent: dimanche 6 septembre 2009 16:23 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ help needed hi i need a code or macro who will clean unwanted spaces and character in the colums conatings email ids like ashish k...@gmail.com. result should be ashishk...@gmail.com koulashish @gmail.com...result should be koulash...@gmail.com koul.ashish @gmail.com result should be koul.ash...@gmail.com thanks ashish --~--~-~--~~~---~--~~ -- 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: help plz
Hi Ashish, Try OpenXL - http://www.openexcel.com -- Regards Ashish Jain (Excel Macros - Google Group Manager) http://www.excelitems.com (Developer of OpenXL) http://www.openexcel.com Excel,VBA,VSTO Trainer +91..40.48.43 -- On Sep 6, 6:06 pm, ashish koul wrote: > hi all > > hi can anyone give me code or macro to clean as well as trim my data in a > sheet > > thanks > ashish --~--~-~--~~~---~--~~ -- 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$$ help needed
hi i need a code or macro who will clean unwanted spaces and character in the colums conatings email ids like ashish k...@gmail.com. result should be ashishk...@gmail.com koulashish @gmail.com...result should be koulash...@gmail.com koul.ashish @gmail.com result should be koul.ash...@gmail.com thanks ashish --~--~-~--~~~---~--~~ -- 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$$ help plz
hi all hi can anyone give me code or macro to clean as well as trim my data in a sheet thanks ashish --~--~-~--~~~---~--~~ -- 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$$ Help to break excel sheet password
Dear All Excel Gurus, I need help to recover my password / crack password for attached file. Regards, Nipun --~--~-~--~~~---~--~~ -- 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: Help regarding automation
Have a look at the attached file. Best regards. Daniel From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Aligahk06 Sent: samedi 5 septembre 2009 14:39 To: excel-macros@googlegroups.com; aamir...@gmail.com; dilipan...@gmail.com; findsarfa...@gmail.com; shafiq_onl...@hotmail.com; soura...@gmail.com; upendrasinghsen...@gmail.com; Al Sulaiman; Bibek . excel engineering.; Excelities.help; Gohar sahab; Muddasar.excilities.; Peter; Richa.Excelities; Sanketham; Harmeet Singh Subject: $$Excel-Macros$$ Help regarding automation Dear All, I have a workbook with sheet1 (name of sheet qty) and sheet2(name of sheet price) I want in Sheet2(price) i.e multiplication of qty and price cell by cell and then sum of each multiplication in a cell. i.e Qty.Sheet price sheet Cell c6:c21 c6:c21 Cell d6:d21 d6:d21 ... upto Cell j6:j21 j6:j21 and so on. I want multiply (qty C6* Price C6 then qtyC7*PriceC7 ..so on till qtyC21*PriceC21) In cell C22 sum of all this multiplication. again (qty D6* Price D6 then qtyD7*Price D7 ..so on till qtyD21*PriceD21) In cell D22 sum of all this multiplication. ... ... upto Col (qty J6* Price j6 then qtyJ7*Price J7 ..so on till qtyJ21*PriceJ21) In cell J22 sum of all this multiplication. Finally in cell F 26 Sum of all sum i.e sum(c22,d22,e22,f22,j22) Hope my problem is clear. Please assist me either through VBA or through Formula or function or any automated technique. I have a lot of workbook and it would take time if i would do it manually. Rgds, Aligahk06 --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~--- AutoMult.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Another milestone of the group : 6000 members
Dear Members, Finally With all your support and good wishes we have completed 6000 Members in our Google group.We have achieved this mark in very short span of time.I hope this group reaches more milestones and help more & more people around the world. Our Google group is a free service. Please let your friends and office colleagues about this group. Here, I would like appreciate the sincere efforts of all time top 10 posters for their remarkable help to group members from their subject knowledge. They really deserve a big applause. On this occasion lets celebrate it again with lots of energy... You suggestions are most welcome again. All Cheers to U... Regards, Ayush Jain [Group Owner] --~--~-~--~~~---~--~~ -- 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: Calculating renewal dates
Eric, If your Begin Date is in cell A2 and cell B2 has the Number of years. To calculate the Renewal Date try the following formula in cell C2: =A2+(B2*365.25) Begin DateYearsRenewal Date - 10/25/2005410/25/2009 Norman On Sat, Sep 5, 2009 at 3:04 PM, Eric wrote: > > > > I'm having a difficult time with something that sounds pretty simple > on the surface but seems to get devilishly hard (at least for me) as I > look further into it. I need to calculate contract renewal dates based > on the original signing date. For a 1 year term it's pretty straight > forward but for contracts that have a 2 year term the problem is more > tricky. We also have a few contracts that have 3 and 5 year terms so > I'd need a solution that is general and can be applied to any length > contract term. > > Here are some examples of the dates I'd need be able to calculate: > > Contract term length: 2 years > > Begin Date Renewal Date > -- > 10/25/2005 10/25/2009 > 12/8/2003 12/8/2009 > 2/27/2004 2/27/2010 > 3/8/20043/8/2010 > 3/27/2002 3/27/2010 > 4/18/2006 4/18/2010 > 4/23/1998 4/23/2010 > 5/1/20065/1/2010 > 5/6/20045/6/2010 > 5/7/20045/7/2010 > 5/24/2006 5/24/2010 > 6/6/20026/6/2010 > 6/25/2004 6/25/2010 > 7/28/2004 7/28/2010 > 8/2/20028/2/2010 > 8/10/2006 8/10/2010 > > > Any ideas or suggestions would be greatly appreciated. > > -Eric > > > > --~--~-~--~~~---~--~~ -- 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: Puzzle #1 - Generate the Sample Pattern (VBA)
Hi Harmeet, That's fantastic. and good that you protected the code. I want everyone to try, so that their logic and vba skills can be sharpened. Well Done Harry. -- Regards Ashish Jain (Excel Macros - Google Group Manager) http://www.excelitems.com (Developer of OpenXL) http://www.openexcel.com Excel,VBA,VSTO Trainer +91..40.48.43 -- On Sep 6, 12:55 pm, Harmeet Singh wrote: > *Hey **Ashish**,**Thanks a lot for this interesting puzzle.* > *Looking forward for more innovative puzzles.* > * > * > *Solution is attachedLet me know if I have done it > appropriately.* > > > > On Sun, Sep 6, 2009 at 10:06 AM, Ashish Jain <26may.1...@gmail.com> wrote: > > Hi All, > > > This is challenge for all excel users. Solve these puzzles and sharpen your > > excel acumen. So, here goes the first puzzle of "Excel Macros Google Group" > > in attached file. > > > -- > > Regards > > Ashish Jain > > (Excel Macros - Google Group Manager) > >http://www.excelitems.com > > (Developer of OpenXL) > >http://www.openexcel.com > > > Excel,VBA,VSTO Trainer > > +91..40.48.43 > > -- > > -- > Thanks & Regards, > > Harmeet Singh > > Sent via BlackBerry Wireless > > Puzzle #1.xls > 109KViewDownload --~--~-~--~~~---~--~~ -- 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: Find the Number
On Sep 5, 5:07 pm, Mahesh wrote: > Dear Firends, > > need ur help here. > > i want to enter number in sheet 2 and want to match it in sheet 1 > if the same number is not in the sheet 1 then it will find the nearest > number either +1 or -1. > > Please check the attached sheet. > > -- > With Love, > Mahesh Bisht > > Book1.xlsx > 15KViewDownload Hi Mahesh, I hope the attached file will help. Regards, Jonell --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~--- Book1_jonell.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Calculating renewal dates
Try (begin date in A1) : =DATE(YEAR(A1)+CEILING(DATEDIF(A1,TODAY(),"y")/2,1)*2,MONTH(A1),DAY(A1)) Regards. Daniel > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel- > mac...@googlegroups.com] On Behalf Of Eric > Sent: samedi 5 septembre 2009 21:05 > To: MS EXCEL AND VBA MACROS > Subject: $$Excel-Macros$$ Calculating renewal dates > > > > > I'm having a difficult time with something that sounds pretty simple on the > surface but seems to get devilishly hard (at least for me) as I look further into > it. I need to calculate contract renewal dates based on the original signing > date. For a 1 year term it's pretty straight forward but for contracts that have > a 2 year term the problem is more tricky. We also have a few contracts that > have 3 and 5 year terms so I'd need a solution that is general and can be > applied to any length contract term. > > Here are some examples of the dates I'd need be able to calculate: > > Contract term length: 2 years > > Begin Date Renewal Date > -- > 10/25/2005 10/25/2009 > 12/8/2003 12/8/2009 > 2/27/2004 2/27/2010 > 3/8/2004 3/8/2010 > 3/27/2002 3/27/2010 > 4/18/2006 4/18/2010 > 4/23/1998 4/23/2010 > 5/1/2006 5/1/2010 > 5/6/2004 5/6/2010 > 5/7/2004 5/7/2010 > 5/24/2006 5/24/2010 > 6/6/2002 6/6/2010 > 6/25/2004 6/25/2010 > 7/28/2004 7/28/2010 > 8/2/2002 8/2/2010 > 8/10/2006 8/10/2010 > > > Any ideas or suggestions would be greatly appreciated. > > -Eric > > --~--~-~--~~~---~--~~ -- 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: Calculating renewal dates
On Sep 6, 5:04 am, Eric wrote: > I'm having a difficult time with something that sounds pretty simple > on the surface but seems to get devilishly hard (at least for me) as I > look further into it. I need to calculate contract renewal dates based > on the original signing date. For a 1 year term it's pretty straight > forward but for contracts that have a 2 year term the problem is more > tricky. We also have a few contracts that have 3 and 5 year terms so > I'd need a solution that is general and can be applied to any length > contract term. > > Here are some examples of the dates I'd need be able to calculate: > > Contract term length: 2 years > > Begin Date Renewal Date > -- > 10/25/2005 10/25/2009 > 12/8/2003 12/8/2009 > 2/27/2004 2/27/2010 > 3/8/20043/8/2010 > 3/27/2002 3/27/2010 > 4/18/2006 4/18/2010 > 4/23/1998 4/23/2010 > 5/1/20065/1/2010 > 5/6/20045/6/2010 > 5/7/20045/7/2010 > 5/24/2006 5/24/2010 > 6/6/20026/6/2010 > 6/25/2004 6/25/2010 > 7/28/2004 7/28/2010 > 8/2/20028/2/2010 > 8/10/2006 8/10/2010 > > Any ideas or suggestions would be greatly appreciated. > > -Eric Hi Eric, My suggestion is to create a column in your table to enter the Contract Period as each record is created and use the formula in the attached file. Regards, Jonell --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~--- ContractEndDate_jonell.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Calculating renewal dates
Hi Eric I have created a solver and same is attached with this email. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/6/09, Eric wrote: > > > > > I'm having a difficult time with something that sounds pretty simple > on the surface but seems to get devilishly hard (at least for me) as I > look further into it. I need to calculate contract renewal dates based > on the original signing date. For a 1 year term it's pretty straight > forward but for contracts that have a 2 year term the problem is more > tricky. We also have a few contracts that have 3 and 5 year terms so > I'd need a solution that is general and can be applied to any length > contract term. > > Here are some examples of the dates I'd need be able to calculate: > > Contract term length: 2 years > > Begin Date Renewal Date > -- > 10/25/2005 10/25/2009 > 12/8/2003 12/8/2009 > 2/27/2004 2/27/2010 > 3/8/20043/8/2010 > 3/27/2002 3/27/2010 > 4/18/2006 4/18/2010 > 4/23/1998 4/23/2010 > 5/1/20065/1/2010 > 5/6/20045/6/2010 > 5/7/20045/7/2010 > 5/24/2006 5/24/2010 > 6/6/20026/6/2010 > 6/25/2004 6/25/2010 > 7/28/2004 7/28/2010 > 8/2/20028/2/2010 > 8/10/2006 8/10/2010 > > > Any ideas or suggestions would be greatly appreciated. > > -Eric > > > > --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~--- Cont.Date - By DILipandey.xls Description: MS-Excel spreadsheet