Show Bid Request VBA Sorting Script in Excel Bid Request Id: 33082 Bookmark in my 'To Do' list Posted by: Christiaan (1 ratings) (Software buyer rating 10) Non-action Ratio: Below Average - 50.00% Buyer Security Verifications: Good Approved on: Oct 30, 2002 4:32:44 AM EDT Bidding Closes: Nov 13, 2002 4:43:32 AM EDT Viewed (by coders): 287 times Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Very Small Business Project: under $100 (USD) Bidding Type: Open Auction Categories: Visual Basic, Other, Misc Enter chat room for this bid request (0 active users at Jul 31, 2003 12:46:23 PM EDT) Description: This is an intelligent "sorting script" (VBA Macro) that is required in MS Excel. A standard formatted excel spreadsheet will consist of two sheets. Sheet one will contain a unique number, there will be 4 other columns. There will be no repeats. Sheet two will contain a jumbled mess of data including data for each of the 4 columns mentioned in sheet one. A test will need to be applied to the second sheet to associate the unique number to the particular rows. This test will be as follows: If any 3 of the 4 pieces of data match (regardless of case used) then the rows are considered to be a match, and will have the unique number attached to them in another column. Those that do not pass the test will be rejected and copied to a third sheet (for future manual processing). The number of rows will always be different, and the number of columns attached to the data after the intial 4 columns will be different. Also since there may be multiple matches, any duplicates need to be identified and rejected as well. Sample data and a specification will be provided. Deliverables: 1) Complete and fully-functional working .bas file. 2) Complete ownership and distribution copyrights to all work purchased. Platform: Must work on MS Excel 2002. Special Conditions / Other: Work must be completed within 7 calendar days of beginning the work. Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.   Bidding/Comments: All monetary amounts on the site are in United States dollars. Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. See all rejected bids (and all comments) Name   Bid Amount    Date   Coder Rating   This bid was accepted by the buyer! Miguel Asdrubal (7 ratings) in Buenos Aires, Buenos Aires Argentina Bid id: 367,066   $10 (USD) Oct 30, 2002 11:22:45 AM EDT  10 (Excellent)     Bid: 10 Hello, When I was reading your requirement; I did it. You have in the attachment the file Rac33082.xls, in the sheet 'Intro' click on 'Sorting' button. If you have any questions, please don't hesitate to contact me at your convenience. I look forward to hearing from you. Best Regards, Best Regards, Miguel           See 6 private reply(ies) to/from Miguel Asdrubal.