Sort data 2 column ?

[adamasmay]

I want to sort column Status (column C) by sort text "Accepted", "Completed", "Handling", "Scheduled", "Closed", "Rejected"
and sort column Remark (column E) by sort have data , blank

Please guide me about it. (VBA , Macro)

[Pepe Le Mokko]

There are instructions at the top of the page on how to post a sample sheet.Thanks

[alansidman]

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your Excel version. Excel versions are indicated similar to 2013, 2016, 2019, O365 etc.
Thanks

[adamasmay]

File input as attached.

[alansidman]

Here is a link to create a customized sort list. Once you have this list created, you can then record a macro to do the sorting for you. If you need assistance with fine tuning the recorded macro, post back in this thread.

https://support.microsoft.com/en-us/...b-ba213ec2fd61

[Marc L]

According to the attachment as 'Rejected' does not exist so the data must be corrected or
this beginner level Excels basics VBA demonstration :

Sub Demo1() 
    With [A1].CurrentRegion.Columns 
       .Item(.Count + 1) = Application.Match(.Item(3), [{"Accepted","Completed","Handling","Scheduled","Closed","Rejected"}], 0) 
       .Item(.Count + 2).Formula = "=ISBLANK(E1)" 
       .Resize(, .Count + 2).Sort .Item(.Count + 1), 1, .Item(.Count + 2), , 1, , , 1 
       .Item(.Count + 1).Resize(, 2).Clear 
    End With 
End Sub  

► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

[adamasmay]

I have a question.
If I move column remark to column AM.

How to edit your code?

[Marc L]

As you should see in my VBA procedure you just need to update the Remark first cell address within the formula …