| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to sort spreadsheet based on values in Column A
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! Here is a visual example and the actual data (see the different worksheet tabs) www.progressivetel.com/~radney4/Scan.xls |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Unique Values in 1 Column based on Date Range in another Column | Excel Worksheet Functions | |||
| Sort a range of data based on another column | Excel Discussion (Misc queries) | |||
| Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
| How do I sort an excel spreadsheet based off of subtotals? | Excel Worksheet Functions | |||
| how do I sort a worksheet based on one column? | New Users to Excel | |||
Hybrid Mode
