| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Arrange sheet in specific order with VBA
I have a report I'm sorting into numerous sheets in the same workbook. The
first sheet is titled "All Records". I want to populate "sheet 6" with all the data from the "All Records" sheet but I want the data in order by specific text in column B. I want all items with "Black" in column B first, followed by all rows with "Red" next, then "Blue" followed by "Green". How would I code something like this? I appreciate your help, thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I arrange names in alphabetic order in an excel sheet | Excel Discussion (Misc queries) | |||
| how to auto arrange in alphabetical order-excel sheet | New Users to Excel | |||
| method for arrange items in alphabetic order in a sheet | Excel Worksheet Functions | |||
| Arrange sheet in specific order | Excel Programming | |||
| arrange cell order | Excel Programming | |||
Threaded Mode
