Hello Harmeet, The issue here is to sort the data in valuation tab as per the data in PV tab. I think formulae can not be helpful in sorting the data. Therefore, could anyone write a macro for this???
Please refer to For Your Information tab in my first post below: Here is the points for your quick idea: 1 Macro has to ask/recognize B4:H6 and B11:B14 from PV Sheet (in this case. Actually in may vary) 2 In Valuation tab, Macro has to select entire row for all the names from the first one (Here, the first name starts at A10) 3 Macro should compare the order of each cell content of Column A/B from Valuation sheet with names/IDs in sheet PV 4 If the first name in PV tab exists in Valuation tab column A, the row has to be brought up to the top of the name list 5 If the name does not exist, a row has to be created there and the name & ID should be entered 6 Macro has to request whether update the Headers or not 7 If No, macro has to stop 8 If Yes, it has to perform a lookup from PV sheet and fill up the VALUES in Valuation tab On Sun, Mar 22, 2009 at 6:15 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 -- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
