Rightly said Harmeet..!! -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062
On Mon, Mar 23, 2009 at 12:42 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 > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
