Harmeet, I am able to do sort & do a lookup and I can also write VBA code for the sort & lookup functions. However, my problem is the macro should sort the names in Valuation tab as per their order in PV tab, irrespective of their current location.
Request you to go through my spreadsheet (especially FYI tab) completely and carefully. Hope you can solve my issue. Maddy On Mar 23, 12:12 pm, Harmeet Singh <harmeet.hew...@gmail.com> wrote: > Hi Maddy, > > Attched file is updated by Sort function. > > Trust me for one thing. > > Formulas are lot more difficult then VBA , When it comes to these kind of > situations. > > Let me know if more updation required. > > > > > > On Sun, Mar 22, 2009 at 8:22 PM, Maddy <ma10ku...@gmail.com> wrote: > > > I found no solution for sorting the names in Valuation tab as per PV > > tab. ??? > > > On Mar 22, 5:45 pm, Harmeet Singh <harmeet.hew...@gmail.com> wrote: > > > Hi, > > > > Due to time constraint couldn't write VBA macro. > > > Sending you updated file, it has formulas and giving required results. As > > > per me for this requirements formulas would be better as compare to VBA. > > > > Feel free to contact for further clarifications or requirements. > > > > On 3/21/09, Mathan Kumar <ma10ku...@gmail.com> wrote: > > > > > Sorry... Missed to attach the spreadsheet... Here you go...!!! > > > > > Maddy - ma10ku...@gmail.com > > > > > On Sun, Mar 22, 2009 at 3:22 AM, Maddy <ma10ku...@gmail.com> wrote: > > > > >> Hello Everyone, > > > > >> Could anyone write an excel macro to do the below tasks (in Excel > > > >> 2003) ? > > > > >> I have a "complete" set of names in a sheet named PV. However, the set > > > >> of names are not together and therefore I need to select the range. > > > >> Here the data need not be in alphabetical order. > > > > >> I have another sheet called "Valuation", where I will be having few of > > > >> the names. Here, too, the starting row of the names can not be > > > >> defined. > > > > >> Now, I would like to sort the rows in sheet Valuation as per their > > > >> order in the earlier sheet PV. If any name is missing in Valuation > > > >> sheet, a new row should be inserted and the Name & ID from sheet PV > > > >> should be created. > > > > >> I have created a sample spreadsheet and included the instructions too. > > > > >> Hope someone will come up with an excellent code. Looking for that... > > > > >> Thanks in advance for your time and efforts. > > > > >> Maddy - ma10ku...@gmail.com > > > > > -- > > > > Best Regards, > > > > Mathan Kumar, > > > > +91 97107 11780 > > > > ma10ku...@yahoo.com > > > > -- > > > Thanks & Regards, > > > > Harmeet Singh > > > > Sort_Sample(1).xls > > > 74KViewDownload > > -- > Thanks & Regards, > > Harmeet Singh > > Sort_Sample(1).xls > 102KViewDownload- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
