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 --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
Sort_Sample.xls
Description: MS-Excel spreadsheet
