$$Excel-Macros$$ NEED HELP on multiple vlookup
Dear All, I need your help. Kindly find the attached data sheet, query & the solution which i need is explained in it. Please help me on the issue since i have to invest a lot of time in solving it. Thanks in advance. -- -- Thanks & Regards, Madhur Baharani OSS Kolkata Mob: 91-9874459054 Mob: 91-9831804654 --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~--- DATA_SHEET.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ need array formula
Hi, How to use {=TABLE(,K11)} this type of function. -- Thanks, Gyanesh Jain, BE, MBA (Finance) +91 98868 68488 Please Save a tree...please don't print this e-mail unless you really need to --~--~-~--~~~---~--~~ -- 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: Excel multiple formula in a cell
Raj: Only one formula, to the best of my knowledge, but that formula may have many "nested" functions. Mike Daniels On Sep 2, 8:06 am, Raj Kumar wrote: > hi, > > i am your new friend and i have some doubt in Excel so i want to ask a > question to you The question is:- > > How many formulas can be applied in a particular cell at a time? > > Thanks a lot > Raj Bharti --~--~-~--~~~---~--~~ -- 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$$ Need help for Production
Dear Brothers & Sisters, I am satiq now I am learning Excel .. That too intresting.. Then could I know about How can I protect my worksheet with hiding formula?.. Satiq Kuwait --~--~-~--~~~---~--~~ -- 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 i can arrange data in Random manner
Hi Uma, Attached file has been revised as per your requirements. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/1/09, Umakant Hale wrote: > > Dear friends, > > but in output i require same value in Random Manner wahtever mentioned in > first column > pls help > will you help > On Wed, Aug 26, 2009 at 9:50 PM, Harmeet Singh > wrote: > >> see attached file >> >> On Wed, Aug 26, 2009 at 8:23 PM, Dilip Pandey wrote: >> >>> Hi Umakant, >>> >>> Attached sheet has two Excel Functions explained which can be used to >>> solve your queries. Thanks. >>> >>> -- >>> DILIP KUMAR PANDEY >>> MBA-HR,B COM(Hons.),BCA >>> Mobile: +91 9810929744 >>> dilipan...@gmail.com >>> dilipan...@yahoo.com >>> New Delhi - 110062 >>> >>> >>> >>> On Tue, Aug 25, 2009 at 3:38 PM, Umakant Hale wrote: >>> pls help i want to arrange attched sheet data i random Br Umakant >>> >>> >>> >>> >> >> >> -- >> >> 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 -~--~~~~--~~--~--~--- test(2) - Revised by DILipandey.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: excel macros -non numeric value
*see attached file* On Wed, Sep 2, 2009 at 1:37 PM, ymusafi wrote: > > Hi All > I want to create a macro that is doing somthing if the cell value has > non numeric value > meaning: > if cell.value=???then > I just need to know what to put instead of the question marks > 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 -~--~~~~--~~--~--~--- Book2.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Run function from different workbook
Hi, I'm running a VBA script from a 'dummy' excel file to convert a txt file into a csv with a specific format. >From the 'dummy' excel several operations are performed as, open txt, add week numbers, create pivot table etc. All operations are performed in the openned txt. One essential thing is to create a column G, which contains the date of the monday of the week specified in column F (week) and E (month). To see which date is actually the monday of that week in that year I'm using John Green's code: (http://www.cpearson.com/excel/ DateTimeVBA.htm). Adding the value to the cell the folowing way: Range("G2").Select Selection.NumberFormat = "m/d/" ActiveCell.FormulaR1C1 = "=WeekStart(RC[-2], RC[-1])" Now the thing is: I cannot run this code (WeekStart) from the just opened txt, I think because the code is not in the txt, but in the dummy excel. WeekStart is a public function. How can I make this work, without needing to copy all data into the dummy file. Thanks, Maarten --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~---
RE: FW: $$Excel-Macros$$ Help Please
Dear Dilip, Tried that option but not able to get exact required output , file attached after a try . please advise & also if there any formula please send. Regards, Prashant From: Dilip Pandey [mailto:dilipan...@gmail.com] Sent: Wednesday, September 02, 2009 5:38 PM To: prashant Cc: excel-macros@googlegroups.com Subject: Re: FW: $$Excel-Macros$$ Help Please Hi Prashant, You can use copy - paste special - transpose option and this will be taken care off in seconds. If your amount is going to change, then you can use formulation. let me know if you need this formulation. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Sep 2, 2009 at 3:00 PM, prashant wrote: Dear Dilip, Any help from you Regards, Prashant From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of prashant Sent: Tuesday, September 01, 2009 1:15 PM To: excel-macros@googlegroups.com Cc: dilipan...@gmail.com Subject: $$Excel-Macros$$ Help Please Dear All, Please help as per attachment Thx in advance Regards, Prashant --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~---
Re: FW: $$Excel-Macros$$ Help Please
Hi Prashant, I am not able to find any attachment in the email sent by you. Please re-attach the workbook with the result which you required as a scenario. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Sep 2, 2009 at 8:28 PM, prashant wrote: > Dear Dilip, > > > > Tried that option but not able to get exact required output , file > attached after a try . please advise & also if there any formula please > send. > > > > Regards, > > > > Prashant > > > > *From:* Dilip Pandey [mailto:dilipan...@gmail.com] > *Sent:* Wednesday, September 02, 2009 5:38 PM > *To:* prashant > *Cc:* excel-macros@googlegroups.com > *Subject:* Re: FW: $$Excel-Macros$$ Help Please > > > > Hi Prashant, > > > > You can use copy - paste special - transpose option and this will be taken > care off in seconds. > > If your amount is going to change, then you can use formulation. let me > know if you need this formulation. Thanks > > -- > DILIP KUMAR PANDEY > MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > On Wed, Sep 2, 2009 at 3:00 PM, prashant wrote: > > Dear Dilip, > > > > Any help from you > > > > Regards, > > Prashant > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *prashant > *Sent:* Tuesday, September 01, 2009 1:15 PM > *To:* excel-macros@googlegroups.com > *Cc:* dilipan...@gmail.com > *Subject:* $$Excel-Macros$$ Help Please > > > > Dear All, > > > > Please help as per attachment > > > > Thx in advance > > > > Regards, > > > > Prashant > > > > > > > > --~--~-~--~~~---~--~~ -- 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$$ Custom Function ...
I've put this function into my Excel file, in the VBA section. I've put it in the Personal.xls Module 1. The worksheet itself. A new Module within the workbook. I've put it everywhere but it doesn't work. I cribbed it from the internet and it's meant to bring back the colour / color value of the font in a cell. All I get is a #VALUE! error. I'm not sure why it wouldn't be working? I'm using Excel 2003 ... -8-8-8-8-8-8- Code : Public Function FGCol(MyRef As Range) As Long FGCol = MyRef.Font.Color End Function -8-8-8-8-8-8- Luke --~--~-~--~~~---~--~~ -- 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 in print menu
Dear group member I have word or excel file containing 15 pages in that i want 1 to 7 pages in Portrait & 8 page as Landscape & again 9 to 15 pages as Portrait. I want each pages of word file with differnt page setup especially margins (eg. page no.1 top margin 1inch, page no.3 top margin 1.5 inch etc) Regards Dharmesh --~--~-~--~~~---~--~~ -- 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$$ Excel multiple formula in a cell
hi, i am your new friend and i have some doubt in Excel so i want to ask a question to you The question is:- How many formulas can be applied in a particular cell at a time? Thanks a lot Raj Bharti --~--~-~--~~~---~--~~ -- 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: excel macros -non numeric value
ymusafi, The following code checks to see whether the cell's contents is numeric or not: Public Function Test(cell As Range) If IsNumeric(cell.Value) Then Debug.Print "Numeric" Else Debug.Print "Not numeric" End If End Function Try it in the Immediate Window by typing: Test Range("A1") Regards, Chris Spicer www.Technicana.com --~--~-~--~~~---~--~~ -- 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$$ Disable 'Select Multiple Items' and '(All)' on PivotTable Report Filter
Greetings I would like to disable the 'Select Multiple Items' and '(All)' features from a PivotTable Report Filter (Page items). I do not know how to do it. I have data for multiple years that I would like to be able to see using the filter, but it makes no sense to add data together from different years. Therefore, I do not want a user to pick All or to Select more than one year. Can anyone help? Regards John --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~---
Re: FW: $$Excel-Macros$$ Help Please
Hi Prashant, You can use copy - paste special - transpose option and this will be taken care off in seconds. If your amount is going to change, then you can use formulation. let me know if you need this formulation. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Sep 2, 2009 at 3:00 PM, prashant wrote: > Dear Dilip, > > > > Any help from you > > > > Regards, > > Prashant > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *prashant > *Sent:* Tuesday, September 01, 2009 1:15 PM > *To:* excel-macros@googlegroups.com > *Cc:* dilipan...@gmail.com > *Subject:* $$Excel-Macros$$ Help Please > > > > Dear All, > > > > Please help as per attachment > > > > Thx in advance > > > > Regards, > > > > Prashant > > > > > > --~--~-~--~~~---~--~~ -- 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: Vlookup Value
Hi Dilip, My requirement is, I want to Vlookup and the value returned is based on M or D. Example Vlookup of table value "A" (Column B) and value "D" (Column C) the value required as result is 26. But i will get answer as 25. Please help me to get it. Regards, Ashwin On Sep 2, 1:35 pm, Dilip Pandey wrote: > Thanks Umesh...!! > > Best Regards, > -- > DILIP KUMAR PANDEY > MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > On Wed, Sep 2, 2009 at 1:43 PM, Umesh Gupta 3 wrote: > > > > > IT IS REALLY GOOD > > > THANKS > > > - Original Message - > > *From:* Dilip Pandey > > *To:* excel-macros@googlegroups.com > > *Sent:* 02 September, 2009 10:53 AM > > *Subject:* $$Excel-Macros$$ Re: Vlookup Value > > > Hi Ashwin, > > > I believe you need multiple values based on single criteria across the data > > range. Same is done and attached herewith. Thanks > > -- > > DILIP KUMAR PANDEY > > MBA-HR,B COM(Hons.),BCA > > Mobile: +91 9810929744 > > dilipan...@gmail.com > > dilipan...@yahoo.com > > New Delhi - 110062 > > > On 9/2/09, Ashwin Gopinath > > > wrote:- Hide quoted text - > > - Show quoted text - --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,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: There is one think Plz Repply Fast
yes it possible Go On right click on chart sheet then go location and select go objective and press enter On Wed, Sep 2, 2009 at 12:14 PM, anil panchal wrote: > Hi Frnd, > > suppose maine pivot table banaya sheet 2 me ab chahta hu ki pivot chart bhi > bane sheet 2 me hi na ki sheet 3 me is it possible or not? > > Thanks & Regards > Anil Kumar > 9278256426 > > > > --~--~-~--~~~---~--~~ -- 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: Thanks a lot
Hey Vidyut... The electrifying man... Thanks for the encouraging words...!!! Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Sep 2, 2009 at 2:22 PM, vidyut more wrote: > Hi > Dilip Thanks a lot. Actualy it can be done by VBA i know it. But i > want to any formula in exce. And ur simply great in excel. 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: There is one think Plz Repply Fast
You are welcome ji..!! Best regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Sep 2, 2009 at 2:13 PM, anil panchal wrote: > > Dear Sir jee > > Thanks, \ *"Dhanyawad" Jee* > > Anil Kumar > > On 9/2/09, Dilip Pandey wrote: >> >> Hi Anil..!! >> >> Yes it is definitely possible. \ *"haan aisa bilkul mumkin hai"* >> Attached file has the description as well as the solution. \ *"jo file >> email me attach hai, usme uttar tatha tareeka bhi samhaya hai"* >> >> >> Thanks, \ *"Dhanyawad"* >> -- >> DILIP KUMAR PANDEY >> MBA-HR,B COM(Hons.),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 110062 >> >> >> >> On Wed, Sep 2, 2009 at 12:14 PM, anil panchal wrote: >> >>> Hi Frnd, >>> >>> suppose maine pivot table banaya sheet 2 me ab chahta hu ki pivot chart >>> bhi bane sheet 2 me hi na ki sheet 3 me is it possible or not? >>> >>> Thanks & Regards >>> Anil Kumar >>> 9278256426 >>> >>> >> >> >> >> >> >> >> > --~--~-~--~~~---~--~~ -- 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: Vlookup Value
Thanks Umesh...!! Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Sep 2, 2009 at 1:43 PM, Umesh Gupta 3 wrote: > IT IS REALLY GOOD > > THANKS > > - Original Message - > *From:* Dilip Pandey > *To:* excel-macros@googlegroups.com > *Sent:* 02 September, 2009 10:53 AM > *Subject:* $$Excel-Macros$$ Re: Vlookup Value > > Hi Ashwin, > > I believe you need multiple values based on single criteria across the data > range. Same is done and attached herewith. Thanks > -- > DILIP KUMAR PANDEY >MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > On 9/2/09, Ashwin Gopinath > > wrote: >> >> >> >> >> --~--~-~--~~~---~--~~ -- 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: Vlookup Value
IT IS REALLY GOOD THANKS - Original Message - From: Dilip Pandey To: excel-macros@googlegroups.com Sent: 02 September, 2009 10:53 AM Subject: $$Excel-Macros$$ Re: Vlookup Value Hi Ashwin, I believe you need multiple values based on single criteria across the data range. Same is done and attached herewith. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/2/09, Ashwin Gopinath wrote: --~--~-~--~~~---~--~~ -- 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$$ excel macros -non numeric value
Hi All I want to create a macro that is doing somthing if the cell value has non numeric value meaning: if cell.value=???then I just need to know what to put instead of the question marks 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$$ VBA: how to repeat a code and count not empty rows
Hello, I would appreciate if you could help me. I have a file with rows where some of them need to be deleted when column E is empty. However, there are several blocks of not empty rows. Therefore, I need the code to be repeated until column A is empty. row = 3 column = 5 number_of_notempty_rows = 0 Do While Not IsEmpty(ActiveSheet.Cells(row, column)) row = row + 1 number_of_notempty_rows = number_of_notempty_rows + 1 Loop Range(Cells(number_of_notempty_rows + 3, 1), Cells (number_of_notempty_rows + 3 + 8, 1)).EntireRow.Delete This code only deletes 9 rows after first block of rows but I need to repeat for other blocks that can have various number of not empty rows. Range(Cells(number_of_notempty_rows + 3+x, 1), Cells (number_of_notempty_rows + 3 + 8+x, 1)).EntireRow.Delete I think I should first always count not empty rows and then repeat this code where x is the number of not empty rows. It is always necessary to delete 9 rows after each block of rows. Thank you in advance Ivana --~--~-~--~~~---~--~~ -- 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: Ignore my previous mail
Hi Moksh, Check out the following links:- http://www.cpearson.com/excel/Classes.aspx http://www.developersdex.com/gurus/articles/636.asp http://www.mrexcel.com/archive/VBA/29829.html Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Sep 2, 2009 at 10:54 AM, MOKSH.. wrote: > Hi Mr Dilip > > moksh this side i need ur help actualy i need to know about the class > module in vba > > 2009/9/2 Dilip Pandey > >> You are always welcome...!!! >> >> Let me know if you need any further help from my side. >> -- >> DILIP KUMAR PANDEY >>MBA-HR,B COM(Hons.),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 110062 >> >> >> On 9/1/09, vidyut more wrote: >>> >>> Hi. >>> Dilip plz ignore my previous mail. i have figure out formula what i >>> want from your formula which provided by u. >>> Thank u very much. >>> >> >> >> >> > > > -- > Moksh > > > > > --~--~-~--~~~---~--~~ -- 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$$ There is one think Plz Repply Fast
Hi Frnd, suppose maine pivot table banaya sheet 2 me ab chahta hu ki pivot chart bhi bane sheet 2 me hi na ki sheet 3 me is it possible or not? Thanks & Regards Anil Kumar 9278256426 --~--~-~--~~~---~--~~ -- 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 on PC No Formula
Hi Vidyut, File is corrected and re-formulated as per your requirements. Same is attached with this email. 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 Wed, Sep 2, 2009 at 11:27 AM, vidyut more wrote: > Hi, Dilip > Last i say i got the formula, but actualy its not working with > following condition. please check file. Thanks in advance. > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> 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 -~--~~~~--~~--~--~--- Grey PC no - By DILipandey.xls Description: MS-Excel spreadsheet