$$Excel-Macros$$ Shortcut to rename or Delete Worksheet
Hi friends, I want to know Shortcut to rename or Delete the worksheet of any Workbook please revert BR, AS it --~--~-~--~~~---~--~~ -- 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$$ Re: Enable V Look up Option on the Excel Sheet.
hi Dilip, u use formula =VLOOKUP($A:$A,Portfolio!$B:$L,COUNTA(Portfolio!$B$1:B$1)+1,0) if i use this =VLOOKUP($A:$A,Portfolio!$B:$L,2,0) then whts the problem ? On Sat, Oct 3, 2009 at 10:30 PM, prashant bhawar wrote: > hi Dilip, > > u use formula > =VLOOKUP($A:$A,Portfolio!$B:$L,COUNTA(Portfolio!$B$1:B$1)+1,0) > > if i use this =VLOOKUP($A:$A,Portfolio!$B:$L,2,0) > then whts the problem ? > > > On Sat, Oct 3, 2009 at 3:28 PM, wrote: > >> Thx a lot >> >> Sent from my BlackBerry® smartphone from Tata Indicom >> -- >> *From: * Dilip Pandey >> *Date: *Sat, 3 Oct 2009 15:04:03 +0530 >> *To: * >> *Subject: *$$Excel-Macros$$ Re: Enable V Look up Option on the Excel >> Sheet. >> >> Hi, >> >> As requested, v-lookup function is incorporated in the attached workbook. >> Note, you have to define something else instead of "fund Name" as a >> base data to be looked for because the same names are appearing more than >> once. For example, fund Id or fund number can work. Thanks, >> >> -- >> DILIP KUMAR PANDEY >>MBA-HR,B COM(Hons.),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 110062 >> >> >> On 10/3/09, Equity Monk wrote: >>> >>> Dear Friends, >>> >>> I am attaching a portfolio. It is a mf portfolio. >>> If you can pls attach a v look up function to it that would be great. >>> >>> The website from where the link can come is http://www.amfiindia.com/. >>> >>> Looking fwd to your help. >>> >>> >>> >> >> >> >> >> >> > > > -- > Warm Regard > > Prashant Bhawar > > ( CA Final ) > -- Warm Regard Prashant Bhawar ( CA Final ) --~--~-~--~~~---~--~~ -- 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$$ PUZZLE Use functions only
Reverse a text or number or mixed value entered in a cell using functions only not VBA. e.g. Say A1 = ABC351D Then the answer in cell A2 should be D153BCA The entered value may be text or number anything but result should be reversed. Regards Sandeep --~--~-~--~~~---~--~~ -- 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$$ Excel Macro
Anybody knows Excel Macro E-books? --~--~-~--~~~---~--~~ -- 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$$ Calculate 10 working days from a given date
Hi, Please help me in the calculating the follow up date of a a particular request. The criteria is as under: - For a particular type of customer, I need to follow up after 10 working days from a given date (the given date can be today/yesterday or a day earlier) and need to exclude even US federal holidays and Sat and Sun - For another type of customer, I need to follow up after 20 calender days from a given date (the given date can be today/yesterday or a day earlier) and need to exclude even US federal holidays and Sat and Sun Can any one help me in writing a formula or a Macro.. Your help in this matter is highly appreciated. -- Thanks and Regards Vinod N --~--~-~--~~~---~--~~ -- 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$$ Re: Macro to split a master list into three lists
so you mean, for example, you want to add a new resource manually, then press a button perhaps to update an output sheet? On 3 Oct, 12:42, Cecilia Chiderski wrote: > Hi, I need your expertise on this... Example attached. I have a list of > resources with different locations. There are 3 possible locations. I need to > split the list into three different tables, one per location, and add total > on each. Number of resources is not fixed, number of locations is always > three (might move to four, but I mean, is a fixed value). > > Any suggestions on a macro to do this?? > > Thanks, > CC > _ > Nuevo Windows Live, un mundo lleno de posibilidades. > Descúbrelo.http://www.microsoft.com/windows/windowslive/default.aspx > > Split by category.xls > 20KViewDownload --~--~-~--~~~---~--~~ -- 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$$ Re: parsing multi line data
Hi, Send me the file i will try to solve it. But give me the original file for getting the correct pattern and exception. If you can't send the file to this group then send me on sandymau...@gmail.com. Regards Sandeep - Original Message - From: "BMWFLYBOY" To: "MS EXCEL AND VBA MACROS" Sent: Saturday, September 26, 2009 1:15 AM Subject: $$Excel-Macros$$ parsing multi line data I have data entries that take up three lines here is an example: LIC # BUSINESS NAME ISSUED TYPE CLASSIFICATION BUSINESS ADDRESSOWNER NAME & ADDRESSBUS PHONE # 10-5319 #1 DRAGON HOUSE 5/11/09 RNW RESTAURANT/ BAR 1799 KIOWA AVE 112 LEE, CHUNG BOU 928-505-8367 LAKE HAVASU CITY AZ 86403 448 SUNFIELD DR, LAKE HAVASU CITY AZ 86406 10 00020531 AMERICAN PACIFIC MORTGAGE 8/10/09 NEW SERVICE: MORTGAGE BANKER BRANCH #53 MYERS KEVIN & JENSEN TWYLA928 854 2053 60 ACOMA BLVD S B100 60 ACOMA BLVD S B 100 LAKE HAVASU CITY AZ 86403 LAKE HAVASU CITY AZ 86403 10-7286 #1 NAILS EXPERT & MORE 1/14/09 RNW SERVICE: NAIL SALON 34 LAKE HAVASU AVE N 8 VU, VIET HUNG & PHAN, MICHELLE 928-854-6080 LAKE HAVASU CITY AZ 86403 34 LAKE HAVASU AVE STE 8, LAKE HAVASU CITY AZ 86403 10-00015642 #1 NAILS EXPERT & MORE 2/05/09 RNW SERVICE: NAIL SALON 1460 BENTLEY BLVD NGUYEN, ANH 928-680-1899 LAKE HAVASU CITY AZ 86403 1451 BENTLEY BLVD, UNKNOWN AZ 10-00015643 #1 NAILS EXPERT & MORE 2/05/09 RNW SERVICE: NAIL SALON 1850 MCCULLOCH BLVD N C3NGUYEN, ANH 928-680-1699 LAKE HAVASU CITY AZ 86403 1460 BENTLYE BLVD, LAKE HAVASU CITY AZ 86404 10-4380 #1 NAILS EXPERT & MORE INC 1/05/09 RNW SERVICE: NAIL TECHNICIAN 2231 MCCULLOCH BLVD N 102 #1 NAILS EXPERT & MORE INC 928-854-7100 LAKE HAVASU CITY AZ 86403 2231 MCCULLOCH BLVD N STE 102, LAKE HAVASU CITY AZ 86403 10-00020217 "HANDS ON" THERAPEUTIC MASSAGE 5/06/09 NEW SERVICE: MASSAGE THERAPY 645 MANZANITA DRBERGER, BONNIE LYNNE928-208-3858 LAKE HAVASU CITY AZ 86404 645 MANZANITA DR, LAKE HAVASU CITY AZ 86404 10 00013426 AMEC EARTH & ENVIRONMENTAL INC 1/20/09 RNW SERVICE: ENGINEERING 10706 SIKES PL STE 250 AMEC EARTH & ENVIRONMENTAL INC 928 854 8030 CHARLOTTE NC 2827710706 SIKES PL STE 250 CHARLOTTE NC 28277 I would like to be able to parse everything in each entry, I have been trying to do this for days but can't get any real good results. I don't know much about this programming stuff so I beg and plead with all of you to help me find a solution. The placement is exactly as it shows in the file so almost nothing lines up correctly. So I can't do text to columns. Ideally I would like each bit of info in it's own column: LIC #/BUSINESS NAME//ISSUED//TYPE//CLASSIFICATION//BUSINESS ADDRESS// OWNER ADDRESS...ETC Thanks for your time and please please please be kind enought to help me out! thanks! -BMWFLYBOY --~--~-~--~~~---~--~~ -- 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$$ populate a column using criterion
customer id customerNew customer 10021pg pg 10021pgr pg 10022dp dp 10022dpadp 10022dp3dp i have two columsn of data which are populated. customer id and customer. The column New customer has to be populated such that new customer has to be equal to column customer when ever they have equal customer ids. for example the first two entries in the new colum are pg since they have equal customer ids. Now this could be populated by either pg or pgr- but pg is repeated more no of times in my original data than pgr . So new customer field will have pg in the first two fields. new customer colmn is populated by using two crieteria 1) Customer id field values must be equl 2) when ever customer id field are same, then populate the last colum with the value of the column customer which is repeated max no of times. how to do this easily in exel pls hlep --~--~-~--~~~---~--~~ -- 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$$ Need help to write numbers into words automatically
Dear group members, Please help to to write numbers into words with currency name automatically. for. eg. if i enter "1,250/365" in any cell then formula or code should give me asnswer in words in any other cell "[Currency Name] Öne Thousand Two Hundred Fifty & [Currency Name for change] 365/1000 Only" i.e Kuwaiti Dinars One Thousand Two Hundred Fifty & Fils 365/1000 Only. Number could be answer of any formula. Please help me. Thanx 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 <><><><><><><><><><><><><><><><><><><><><><> 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$$ Re: Enable V Look up Option on the Excel Sheet.
Hi Prashant, Problem would be :- you'll have to manually change the "column index number", if you drag the formula to right side or to down. In my formula, it will automatically change from 2 to 3 then 4, then 5 and so on. Hope this solves your query. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/3/09, Prashant Bhawar wrote: > > hi Dilip, > > > u use formula =VLOOKUP($A:$A,Portfolio!$B:$ > L,COUNTA(Portfolio!$B$1:B$1)+1,0) > > if i use this =VLOOKUP($A:$A,Portfolio!$B:$L,2,0) > then whts the problem ? > > > On Sat, Oct 3, 2009 at 10:30 PM, prashant bhawar > wrote: > >> hi Dilip, >> >> u use formula >> =VLOOKUP($A:$A,Portfolio!$B:$L,COUNTA(Portfolio!$B$1:B$1)+1,0) >> >> if i use this =VLOOKUP($A:$A,Portfolio!$B:$L,2,0) >> then whts the problem ? >> >> >> On Sat, Oct 3, 2009 at 3:28 PM, wrote: >> >>> Thx a lot >>> >>> Sent from my BlackBerry® smartphone from Tata Indicom >>> -- >>> *From: *Dilip Pandey >>> *Date: *Sat, 3 Oct 2009 15:04:03 +0530 >>> *To: * >>> *Subject: *$$Excel-Macros$$ Re: Enable V Look up Option on the Excel >>> Sheet. >>> >>> >>> Hi, >>> >>> As requested, v-lookup function is incorporated in the attached workbook. >>> Note, you have to define something else instead of "fund Name" as a >>> base data to be looked for because the same names are appearing more than >>> once. For example, fund Id or fund number can work. Thanks, >>> >>> -- >>> DILIP KUMAR PANDEY >>>MBA-HR,B COM(Hons.),BCA >>> Mobile: +91 9810929744 >>> dilipan...@gmail.com >>> dilipan...@yahoo.com >>> New Delhi - 110062 >>> >>> >>> On 10/3/09, Equity Monk wrote: Dear Friends, I am attaching a portfolio. It is a mf portfolio. If you can pls attach a v look up function to it that would be great. The website from where the link can come is http://www.amfiindia.com/. Looking fwd to your help. >>> >>> >>> >>> >>> >>> >> >> >> >> >> -- >> Warm Regard >> >> Prashant Bhawar >> >> ( CA Final ) >> > > > > -- > Warm Regard > > Prashant Bhawar > > ( CA Final ) > > > > --~--~-~--~~~---~--~~ -- 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$$ Re: Shortcut to rename or Delete Worksheet
Hi, Below is what I generally use:- To rename a worksheet:- Alt+ O + H + R To delete a worksheet:- Alt+ E + L Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/3/09, AS it wrote: > > > Hi friends, > I want to know Shortcut to rename or Delete the worksheet of any > Workbook > > please revert > > BR, > AS it > > > > --~--~-~--~~~---~--~~ -- 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$$ Re: Excel Macro
Hi Karthikeyan, Go to this "group" ' s home page and visit "Files" section. Alternatively, you can also search web for free e-books. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/3/09, karthikeyan wrote: > > > Anybody knows Excel Macro E-books? > > > > --~--~-~--~~~---~--~~ -- 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$$ Re: Calculate 10 working days from a given date
Hi Vinod, You can use an inbuilt function of Excel viz. "Workday" to achive the required result. Same is explained in the attachment. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/3/09, Vinod N wrote: > > Hi, > > Please help me in the calculating the follow up date of a a particular > request. The criteria is as under: > > >- For a particular type of customer, I need to follow up after 10 >working days from a given date (the given date can be today/yesterday or a >day earlier) and need to exclude even US federal holidays and Sat and Sun >- For another type of customer, I need to follow up after 20 calender >days from a given date (the given date can be today/yesterday or a day >earlier) and need to exclude even US federal holidays and Sat and Sun > > > > Can any one help me in writing a formula or a Macro.. > > > Your help in this matter is highly appreciated. > -- > Thanks and Regards > > Vinod N > > > > > --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~--- Follow up date - by DILipandey.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Enable V Look up Option on the Excel Sheet.
Prashant, You are always welcome. Alternatively, Depending on the scenario, you can also use V-lookup & Match functions - to lookup values from a data range in which respective target columns can shift to left or right side any time. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/4/09, Prashant Bhawar wrote: > > thanks Dilip > > On Sun, Oct 4, 2009 at 3:20 PM, Dilip Pandey wrote: > >> Hi Prashant, >> >> Problem would be :- you'll have to manually change the "column index >> number", if you drag the formula to right side or to down. In my formula, >> it will automatically change from 2 to 3 then 4, then 5 and so on. >> Hope this solves your query. Thanks >> >> -- >> DILIP KUMAR PANDEY >>MBA-HR,B COM(Hons.),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 110062 >> >> >> On 10/3/09, Prashant Bhawar wrote: >> >>> hi Dilip, >>> >>> >>> u use formula =VLOOKUP($A:$A,Portfolio!$B:$ >>> L,COUNTA(Portfolio!$B$1:B$1)+1,0) >>> >>> if i use this =VLOOKUP($A:$A,Portfolio!$B:$L,2,0) >>> then whts the problem ? >>> >>> >>> >>> On Sat, Oct 3, 2009 at 10:30 PM, prashant bhawar < >>> bhawar.prs...@gmail.com> wrote: >>> >>> hi Dilip, u use formula =VLOOKUP($A:$A,Portfolio!$B:$L,COUNTA(Portfolio!$B$1:B$1)+1,0) if i use this =VLOOKUP($A:$A,Portfolio!$B:$L,2,0) then whts the problem ? On Sat, Oct 3, 2009 at 3:28 PM, wrote: > Thx a lot > > Sent from my BlackBerry® smartphone from Tata Indicom > -- > *From: *Dilip Pandey > *Date: *Sat, 3 Oct 2009 15:04:03 +0530 > *To: * > *Subject: *$$Excel-Macros$$ Re: Enable V Look up Option on the Excel > Sheet. > > > Hi, > > As requested, v-lookup function is incorporated in the > attached workbook. Note, you have to define something else instead of > "fund > Name" as a base data to be looked for because the same names are > appearing more than once. For example, fund Id or fund number can work. > Thanks, > > -- > DILIP KUMAR PANDEY >MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > On 10/3/09, Equity Monk wrote: >> >> Dear Friends, >> >> I am attaching a portfolio. It is a mf portfolio. >> If you can pls attach a v look up function to it that would be great. >> >> The website from where the link can come is http://www.amfiindia.com/ >> . >> >> Looking fwd to your help. >> >> >> > > > > > > -- Warm Regard Prashant Bhawar ( CA Final ) >>> >>> >>> >>> -- >>> Warm Regard >>> >>> Prashant Bhawar >>> >>> ( CA Final ) >>> >>> >>> >>> >>> >> >> > > > -- > Warm Regard > > Prashant Bhawar > > ( CA Final ) > --~--~-~--~~~---~--~~ -- 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$$ Re: Need help to write numbers into words automatically
Hi Zaheer, Web is filled-up with these types of automation codes, below is one of them:- http://www.ozgrid.com/VBA/ValueToWords.htm Off-course you have to customize the solution at your end as well :- which is a fare expectation, I believe...!!! Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/4/09, ~ Z A H E E R ~ wrote: > > Dear group members, > > Please help to to write numbers into words with currency > name automatically. > > for. eg. if i enter "1,250/365" in any cell then formula or code should > give me asnswer in words in any other cell "[Currency Name] Öne Thousand Two > Hundred Fifty & [Currency Name for change] 365/1000 Only" > > i.e Kuwaiti Dinars One Thousand Two Hundred Fifty & Fils 365/1000 Only. > > Number could be answer of any formula. > > Please help me. > > Thanx 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 <><><><><><><><><><><><><><><><><><><><><><> 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$$ Re: populate a column using criterion
Hi Subs, Good job. Well drafted query and slightley lenghtly too. I have given a try in the attached file, assuming that the data would always be sorted on "Customer Id", as given by you in the scenario. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/4/09, subs wrote: > > > customer id customerNew customer > 10021pg pg > 10021pgr pg > 10022dp dp > 10022dpadp > 10022dp3dp > > i have two columsn of data which are populated. customer id and > customer. The column New customer has to be populated such that new > customer has to be equal to column customer when > ever they have equal customer ids. for example the first two entries > in the new colum are pg since they have equal customer ids. Now this > could be populated by either pg or pgr- but pg is repeated more no > of > times in my original data than pgr . So new customer field will have > pg in the > first two fields. > > new customer colmn is populated > by using two crieteria > > > 1) Customer id field values must be equl > 2) when ever customer id field are same, then populate the last > colum > with the value of the column customer which is repeated max no of > times. > > how to do this easily in exel pls hlep > > > > > --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~--- customer ID - By DILipandey.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Write numbers in word
Hi Zaheer, Just answered this one a while ago. Check out and let me know if you did'nt find that email. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/2/09, ~ Z A H E E R ~ wrote: > > Dear group members, > > Please help to to write numbers into words automatically. > > for. eg. if i enter "1,250/365" in any cell then formula or code should > give me asnswer in words in any other cell "[Currency Name] Öne Thousand Two > Hundred Fifty & [Currency Name for change] 365/1000 Only" > > i.e Kuwaiti Dinars One Thousand Two Hundred Fifty & Fils 365/1000 Only. > > Number could be answer of any formula. > > Please help me. > > Thanx 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 <><><><><><><><><><><><><><><><><><><><><><> 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$$ Re: PUZZLE Use functions only
*Had to create an UDF...see attached file.not sure if it can be done using formula in one cell.* Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless On Sat, Oct 3, 2009 at 10:41 PM, Sandeep wrote: > Reverse a text or number or mixed value entered in a cell using functions > only not VBA. > > e.g. > Say A1 = ABC351D > > Then the answer in cell A2 should be D153BCA > > The entered value may be text or number anything but result should be > reversed. > > Regards > Sandeep > > > > > --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~--- rt.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: PUZZLE Use functions only
hi i here attached solution hope this is right. On Sat, Oct 3, 2009 at 10:41 PM, Sandeep wrote: > Reverse a text or number or mixed value entered in a cell using functions > only not VBA. > > e.g. > Say A1 = ABC351D > > Then the answer in cell A2 should be D153BCA > > The entered value may be text or number anything but result should be > reversed. > > Regards > Sandeep > > > > -- Warm Regard Prashant Bhawar ( CA Final ) --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~--- puzzel solved-prashant.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: PUZZLE Use functions only
Hi Prashant, Your answer is correct upto an extent but not fully correct because your answer has a limit of 16 character if you can increase it to 256 or above then it is ok. Thanks & Regards Sandeep - Original Message - From: Prashant Bhawar To: excel-macros@googlegroups.com Sent: Sunday, October 04, 2009 3:10 PM Subject: $$Excel-Macros$$ Re: PUZZLE Use functions only hi i here attached solution hope this is right. On Sat, Oct 3, 2009 at 10:41 PM, Sandeep wrote: Reverse a text or number or mixed value entered in a cell using functions only not VBA. e.g. Say A1 = ABC351D Then the answer in cell A2 should be D153BCA The entered value may be text or number anything but result should be reversed. Regards Sandeep -- Warm Regard Prashant Bhawar ( CA Final ) --~--~-~--~~~---~--~~ -- 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$$ Re: populate a column using criterion
hi Dilip how would i repeat the formula for the rest of the cells in my spreadsheet. because i do copy and paste+ special+formula, it is gving me value"dp" for all the cells. dp as you could see is the last value in yr spreadsheet. Also does this work when there is only one customer id and no duplicates. thanks for yr response. On Sun, Oct 4, 2009 at 7:21 AM, Dilip Pandey wrote: > Hi Subs, > Good job. Well drafted query and slightley lenghtly too. > I have given a try in the attached file, assuming that the data would > always be sorted on "Customer Id", as given by you in the scenario. Thanks. > > -- > DILIP KUMAR PANDEY >MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > On 10/4/09, subs wrote: >> >> >> customer id customerNew customer >> 10021pg pg >> 10021pgr pg >> 10022dp dp >> 10022dpadp >> 10022dp3dp >> >> i have two columsn of data which are populated. customer id and >> customer. The column New customer has to be populated such that new >> customer has to be equal to column customer when >> ever they have equal customer ids. for example the first two entries >> in the new colum are pg since they have equal customer ids. Now this >> could be populated by either pg or pgr- but pg is repeated more no >> of >> times in my original data than pgr . So new customer field will have >> pg in the >> first two fields. >> >> new customer colmn is populated >> by using two crieteria >> >> >> 1) Customer id field values must be equl >> 2) when ever customer id field are same, then populate the last >> colum >> with the value of the column customer which is repeated max no of >> times. >> >> how to do this easily in exel pls hlep >> >> >> >> --~--~-~--~~~---~--~~ -- 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$$ Re: Shortcut to rename or Delete Worksheet
Thanks a lot for the shortcut, I have been looking for these stuffs Hugs From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Dilip Pandey Sent: Sunday, October 04, 2009 12:59 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Shortcut to rename or Delete Worksheet Hi, Below is what I generally use:- To rename a worksheet:- Alt+ O + H + R To delete a worksheet:- Alt+ E + L Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/3/09, AS it wrote: Hi friends, I want to know Shortcut to rename or Delete the worksheet of any Workbook please revert BR, AS it 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$$ Re: populate a column using criterion
customer id customer New customer 10021 pg pg 10021 pgr pg 10022 st pg 10022 dpa pg 10022 dp pg 101223 ac pg 101223 ade pg 10045 adr if i change the customer ids little bit, i am getting the output as shown above under the new customer column. Is there something missing in the formula or am i doing some thing wrong. On Sun, Oct 4, 2009 at 7:21 AM, Dilip Pandey wrote: > Hi Subs, > Good job. Well drafted query and slightley lenghtly too. > I have given a try in the attached file, assuming that the data would > always be sorted on "Customer Id", as given by you in the scenario. Thanks. > > -- > DILIP KUMAR PANDEY >MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > On 10/4/09, subs wrote: >> >> >> customer id customerNew customer >> 10021pg pg >> 10021pgr pg >> 10022dp dp >> 10022dpadp >> 10022dp3dp >> >> i have two columsn of data which are populated. customer id and >> customer. The column New customer has to be populated such that new >> customer has to be equal to column customer when >> ever they have equal customer ids. for example the first two entries >> in the new colum are pg since they have equal customer ids. Now this >> could be populated by either pg or pgr- but pg is repeated more no >> of >> times in my original data than pgr . So new customer field will have >> pg in the >> first two fields. >> >> new customer colmn is populated >> by using two crieteria >> >> >> 1) Customer id field values must be equl >> 2) when ever customer id field are same, then populate the last >> colum >> with the value of the column customer which is repeated max no of >> times. >> >> how to do this easily in exel pls hlep >> >> >> >> --~--~-~--~~~---~--~~ -- 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$$ Re: Shortcut to rename or Delete Worksheet
You are welcome!! Let "Group" know, if you need anyother Excel Keyboard shortcut or Excel Function shortcut. Thanks & Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/4/09, janet dickson wrote: > > Thanks a lot for the shortcut, I have been looking for these stuffs > > > > > > Hugs > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *Dilip Pandey > *Sent:* Sunday, October 04, 2009 12:59 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Re: Shortcut to rename or Delete Worksheet > > > > Hi, > > Below is what I generally use:- > > To rename a worksheet:- Alt+ O + H + R > > To delete a worksheet:- Alt+ E + L > > > > Best Regards, > -- > DILIP KUMAR PANDEY >MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > > On 10/3/09, *AS it* wrote: > > > Hi friends, > I want to know Shortcut to rename or Delete the worksheet of any > Workbook > > please revert > > BR, > AS it > > > > > --~--~-~--~~~---~--~~ -- 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$$ Re: Macro to update another Macro?
Sounds good Paul!! Thanks!! On Oct 3, 4:52 pm, Paul Schreiner wrote: > Actually, I might be able to help here. > I'll have to wait until I get back to work on Monday though! > > Paul > > > From: Chechu > To: MS EXCEL AND VBA MACROS > Sent: Saturday, October 3, 2009 7:48:53 AM > Subject: $$Excel-Macros$$ Re: Macro to update another Macro? > > The VBA code is Password protected AND resides in a remote computer. I > developed the protected VBA Code, and I know the password. This is an > Excel tool that I sent to all my department two weeks ago, and now I > figured out that has an error in a Macro. So instead of sending a NEW > tool, I wanted to send a Macro to correct the Macro in the original > file.. Paul, I am not trying to do anything ilegal here!!! I > developed the original file, and I am trying to change it. > > Thanks, > C > > On Oct 2, 9:24 am, Paul Schreiner wrote: > > > > > Let's clarify something. > > > IS the VBA CODE PASSWORD PROTECTED? > > or does it simply reside at a remote location? > > > There's a difference between having the VBA > > code "protected" and it simply being "inaccessible". > > > If the VBA code is password protected, and > > you don't know the password, then you can't do > > what you're asking. > > > '= > > In my company, if you're not in the I.T. department > > (computer support) being in possession of a > > "password breaker" is a violation of Security Policy > > and cause for termination. > > '= > > > But if the reason is that the files reside on remote > > computers, but the VBA code isn't actually "locked", > > then I can send you some code that you can > > modify to remove the code modules and import your own! > > > Paul > > > > > From: Chechu > > To: MS EXCEL AND VBA MACROS > > Sent: Friday, October 2, 2009 5:41:50 AM > > Subject: $$Excel-Macros$$ Re: Macro to update another Macro? > > > Yes, that's the challenge!! I can't unlock the VBA Code, because the > > file resides on each user's computer. I have to send a new file with a > > Macro to update it > > Thanks! > > CC > > > On Oct 1, 3:49 pm, Paul Schreiner wrote: > > > > If you can unlock the VBA code, then it's fairly simple > > > to remove an entire module and import another. > > > But first you have to be able to unlock the VBA. > > > > Paul > > > > > > > From: Cecilia Chiderski > > > To: excel-macros@googlegroups.com > > > Sent: Thursday, October 1, 2009 12:37:25 PM > > > Subject: $$Excel-Macros$$ Macro to update another Macro? > > > > Hi, I have an Excel file with a locked VBA code. I need to create in a > > > separated Excel file a Macro to update a Macro stored in this first > > > Excel. I read some useful information in the web, but still can't write > > > the appropriate code to do it. Can somebody send an example?? > > > Thanks, > > > CC > > > > > > > Charlas más divertidas con el nuevo Windows Live Messenger- 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 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$$ Re: Macro to split a master list into three lists
Easier!! Given a sheet with the format I sent, I need to create an output sheet opened by resource location. On Oct 3, 3:33 pm, jamesdavey wrote: > so you mean, for example, you want to add a new resource manually, > then press a button perhaps to update an output sheet? > > On 3 Oct, 12:42, Cecilia Chiderski wrote: > > > > > Hi, I need your expertise on this... Example attached. I have a list of > > resources with different locations. There are 3 possible locations. I need > > to split the list into three different tables, one per location, and add > > total on each. Number of resources is not fixed, number of locations is > > always three (might move to four, but I mean, is a fixed value). > > > Any suggestions on a macro to do this?? > > > Thanks, > > CC > > _ > > Nuevo Windows Live, un mundo lleno de posibilidades. > > Descúbrelo.http://www.microsoft.com/windows/windowslive/default.aspx > > > Split by category.xls > > 20KViewDownload- 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 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$$ Re: macro help needed
Never mind, I received help elsewhere. On Oct 2, 11:55 pm, vespid wrote: > I'm making excel macros for the first time and getting things figured > out, but I have a few questions: > > What code do I use to delete columns that have all empty cells EXCEPT > the top cell (row 1) that contains any of a number of headings? I need > to insert this into an existing macro. > > What code do I use to shade every other row (preferably even numbered) > light grey after selecting a "currentregion" ? Again, to put inside an > existing macro. > > A related question: When I find code help on the web, it usually > starts with "sub" and ends with "end sub" so how do I insert that into > an existing macro? It looks like a "sub within a sub" doesn't work. > > Thank you for your attention. > > Vespid --~--~-~--~~~---~--~~ -- 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$$ Re: Write numbers in word
Dear Dilip, I am not as good as you are. So, could you pls modify the Macro to suite Indian Curreny i.e. Rupees (Rs) and Paisa. Thanks On Sun, Oct 4, 2009 at 4:58 PM, Dilip Pandey wrote: > Hi Zaheer, > > Just answered this one a while ago. Check out and let me know if you > did'nt find that email. Thanks, > -- > DILIP KUMAR PANDEY >MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > On 10/2/09, ~ Z A H E E R ~ wrote: >> >> Dear group members, >> >> Please help to to write numbers into words automatically. >> >> for. eg. if i enter "1,250/365" in any cell then formula or code should >> give me asnswer in words in any other cell "[Currency Name] Öne Thousand Two >> Hundred Fifty & [Currency Name for change] 365/1000 Only" >> >> i.e Kuwaiti Dinars One Thousand Two Hundred Fifty & Fils 365/1000 Only. >> >> Number could be answer of any formula. >> >> Please help me. >> >> Thanx 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 <><><><><><><><><><><><><><><><><><><><><><> 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$$ populate a column based on existing criterion
customer dzip New Customer proctoandg 10024 procto procto 10024 procto procto 10024procto bambo 13456 bambospecies bambospecies 13456 bambospecies barbs 200011 barbs bangal 10022 bangal I have two columsn of data which are populated. customer and dzip. The column New customer has to be populated such that new customer has to be equal to column customer when ever they have equal dzips. for example the first two entries in the new colum are procto since they have equal dzips. Now this could be populated by either proctoandg or procto- but procto is repeated more no of times in my original data than proctoandg . So new customer field will have procto in the first two fields. So bottomline new customer colmn is populated by using two crieteria 1)Dzip field values must be equl 2) when ever dzip field are same, then populate the last colum with the value of the column customer which is repeated max no of times. \\ Thanks for any help . help is appreciated. --~--~-~--~~~---~--~~ -- 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$$ Re: Enable V Look up Option on the Excel Sheet.
There are many lookups, what kind of information you need to warrant the lookup function. Please tell us what is your problem precisely. dont make us guess. On Sat, Oct 3, 2009 at 12:20 PM, Equity Monk wrote: > Dear Friends, > > I am attaching a portfolio. It is a mf portfolio. > If you can pls attach a v look up function to it that would be great. > > The website from where the link can come is http://www.amfiindia.com/. > > Looking fwd to your 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 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$$ Re: Calculate 10 working days from a given date
Hi Dilip, Thanks a tonn for your kind help. There is a typo in the second criteria which i send out earlier. Please read it as under: For other Customers, I need to follow up after 20*/25/30* calender days (depending upon the customer) from a given date (the given date can be today/yesterday or a day earlier) and the *resultant date** **should not fall on a US federal holidays,Sat or Sun* Thanks in advance Vinod N On Sun, Oct 4, 2009 at 4:10 PM, Dilip Pandey wrote: > Hi Vinod, > > You can use an inbuilt function of Excel viz. "Workday" to achive the > required result. Same is explained in the attachment. Thanks. > -- > DILIP KUMAR PANDEY >MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > On 10/3/09, Vinod N wrote: >> >> Hi, >> >> Please help me in the calculating the follow up date of a a particular >> request. The criteria is as under: >> >> >>- For a particular type of customer, I need to follow up after 10 >>working days from a given date (the given date can be today/yesterday or a >>day earlier) and need to exclude even US federal holidays and Sat and Sun >>- For another type of customer, I need to follow up after 20 calender >>days from a given date (the given date can be today/yesterday or a day >>earlier) and need to exclude even US federal holidays and Sat and Sun >> >> >> >> Can any one help me in writing a formula or a Macro.. >> >> >> Your help in this matter is highly appreciated. >> -- >> Thanks and Regards >> >> Vinod N >> >> >> > > > > > > -- Thanks and Regards Vinod N --~--~-~--~~~---~--~~ -- 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$$ status bar
dear excel genuises, may i request your help how to change the default message in excel 2003 status bar? and prevent the user from changing it. thanks a lot. may god shower you with graces. dellosa --~--~-~--~~~---~--~~ -- 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$$ Unsubscribe
Kindly unsubscribe me from the group. Extreme Regards Mahreen --~--~-~--~~~---~--~~ -- 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$$ RGB cell values
Hi All Please provide with a code which can put RGB cell values in colored cells. Hugs --~--~-~--~~~---~--~~ -- 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$$ Re: Unsubscribe
This is done !! -Ayush Jain On Oct 5, 9:54 am, Mahreen Ellahi wrote: > Kindly unsubscribe me from the group. > > Extreme Regards > Mahreen --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~---