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)
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)
There are instructions at the top of the page on how to post a sample sheet.Thanks
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
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
File input as attached.
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
According to the attachment as 'Rejected' does not exist so the data must be corrected or
this beginner level Excels basics VBA demonstration :
PHP Code:
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 » ! ◄ ◄
I have a question.
If I move column remark to column AM.
How to edit your code?
As you should see in my VBA procedure you just need to update the Remark first cell address within the formula …
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks