Automatic Sorting Macro for Text Values

Originally Posted by Marc L

Hey,

as point 4 is unclear, well elaborate it ! (Sort each section ok but what is the key column ?!)
Or just post an attachment of the expected result according to your initial attachment …

Hey Marc,

My apologies! I did not mean to be unclear on point 4. I will edit the original post to be clearer.

What I meant is that I would like to alphabetize within each section. Here is an example of what I mean:

Row number | Status | Style #
1 | C | BC APPLES
2 | C | BC ZEBRAS
3 | P | BC BASEBALL
4 | P | BC COFFEE
5 | N | BC AWESOME
6 | N | BC DOG MOM
7 | I | BC MAGICAL
8 | I | BC NIGHT SKY
9 | D | BC OH MY GOD
10 | I | BC PREPARE
11 | D | CH AMAZING
12 | I | CH BASEBALL

As you can see, within each section of status C, P, N, and I/D, the items are sorted by alphabetical style number. I hope this makes it clear what I want to do! Thank you!