OilEconomist
Active Member
- Joined
- Dec 26, 2016
- Messages
- 421
- Office Version
- 2019
- Platform
- Windows
Thanks in advance for your assistance.
How would I created a VBA code to do a special sort based on the following criteria.
(1) First sort by the values set forth in columns D and E in the given order. Basically the data set with N rows (Range("A3:T" & LastRow)) I want to sort in the following order (two criteria). So first it will gather all data that have red as an entry in column D and circles in column E.
Once it sorts based on that, I would then like it to sort within each of those based on
(2) Column D in alphabetic order
(3) Column A based on date.
At the end of the day, I first want it to sort on circles and red (combination) and then within circles and red, sort based on column D and then column A. Then do the same thing with each entry in column E and D.
How would I created a VBA code to do a special sort based on the following criteria.
(1) First sort by the values set forth in columns D and E in the given order. Basically the data set with N rows (Range("A3:T" & LastRow)) I want to sort in the following order (two criteria). So first it will gather all data that have red as an entry in column D and circles in column E.
Once it sorts based on that, I would then like it to sort within each of those based on
(2) Column D in alphabetic order
(3) Column A based on date.
At the end of the day, I first want it to sort on circles and red (combination) and then within circles and red, sort based on column D and then column A. Then do the same thing with each entry in column E and D.
