Hi, This is close to what I am needing. I suspect that I didn't explain what I needed properly. The data in columns B,C and D are already populated. These three fields (BCD) are tied to this one particular reel. My situation is this: Columns BCD are from a report that I can pull that shows this material in a storage bin. The parts are in no particular order. I then want to scan the material in order, and have the data in columns BCD resort based on the order of Column A. Also... (and yes... I know I am being greedy here) If I were to scan a reel into Column A that is not in the report (Columns B,C,D) I would need the scan in column A to remain in that same position and the data in Columns B,C,D not to populate or give some sort of error indicating no matching data found.
I provided a better example that should hopefully be a better visual than my written explanation. See Example and Actual Data Worksheets. Thanks again! Original Message: ----------------- From: Harmeet Singh harmeet.hew...@gmail.com Date: Thu, 10 Sep 2009 02:10:25 +0530 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Need to sort spreadsheet based on values in Column A *See attached file........* On Wed, Sep 9, 2009 at 11:08 PM, rad...@progressivetel.com < rad...@progressivetel.com> wrote: > All you wise and mighty Excel gurus... I have the attached spreadsheet. I > will be scanning in the values (via a barcode scanner) into column A. What > I then need is a macro that will leave the Column A values in the order > that they appear, but then sort columns B,C and D to match the value in > Column C to that of Column A. The number of rows may vary, so it would be > nice to have something that an amateur like myself could modify (or that > would work with any number of rows). > > Thanks in advance! > > -------------------------------------------------------------------- > mail2web.com - Microsoft® Exchange solutions from a leading provider - > http://link.mail2web.com/Business/Exchange > > > > > -- Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless -------------------------------------------------------------------- myhosting.com - Premium Microsoft® Windows® and Linux web and application hosting - http://link.myhosting.com/myhosting --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
Scan.xls
Description: Scan.xls
