Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi I want write a macro to sort a spreadsheet with the rows being ordered
from a particular collumn which contain the following letters: W, SA, SA+, ST and blank cells. I need the rows to be sorted in that order from top to bottom. I.E. a;; the `W` rows first, all the ` SA` rows next etc. Now, I know I could create a collumn next to it with perhaps a vlookup reference of say W=1. SA =2 etc, and then sort on that instead, but belive it or not, I`m almost out of collumns (it`s a big spreadsheet) and also some of my other refences might be affected if I go and plonk another collumn in now. Any ideas? Thanks guys RR1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sorting multiple columns alphabetically | Excel Discussion (Misc queries) | |||
Sorting columns alphabetically | Excel Worksheet Functions | |||
HOW DO I SORT ALPHABETICALLY SO THAT DOUBLE LETTERS (AA) FOLLOWS Z | Excel Discussion (Misc queries) | |||
Sorting Alphabetically | Excel Discussion (Misc queries) | |||
Sorting data in a cell alphabetically | Excel Worksheet Functions |