
Originally Posted by
millz
Hi Recepkendir, you don't need VBA to perform such simple sorting. You can perform below steps to sort them like what you wanted.
1) your table is missing out Column A. Select cell B2, from Excel's ribbon menu, "Table Tools" design should appear, click on Resize Table on the extreme left, and change =$B$2:$G$32 to =$A$2:$G$32
2) now select cell A2 and click on Data -> Sort, Excel should automatically highlight all data in the table and a dialog for sorting should appear
3) under "Sort by", select "Status", and select "Z to A" order
4) click on "Add Level", under "Then by", select "Priority", and under Order, select Custom List.
5) "NEW LIST" should be highlighted by default, click on "Add", and type in "High", "Medium", "Low" on separate lines. Click OK, and OK again
Edit: I am using Excel 2007, if you have a different version the steps may be different, I am not sure.
Bookmarks