Can i set a formula for sorting in excel.

Closed
shan_asa Posts 7 Registration date Sunday October 29, 2017 Status Member Last seen December 5, 2017 - Dec 5, 2017 at 03:53 AM
 Blocked Profile - Dec 6, 2017 at 04:29 PM
Hello,

Is it possible to set a rule in excel that the entered details will be sorted automatically by a set criteria?

1 reply

Blocked Profile
Dec 5, 2017 at 05:10 PM
Yes, it is possible.

Here is an example of what it looks like:

Range("A6:AZ9999").Sort key1:=Range("AW5"), _
order1:=xlDescending, Header:=xlNo

0
shan_asa Posts 7 Registration date Sunday October 29, 2017 Status Member Last seen December 5, 2017
Dec 5, 2017 at 11:44 PM
I want to automatically sort the rage from A3 to I1000 based on date entered in A3 to A1000. Were should I be putting the formula.
0
Blocked Profile
Dec 6, 2017 at 04:29 PM
IN a Module. Have you tried to record a macro of this function? Record a macro, perform the work as you want it, then stop the recorder. Now, whenever you want that action to be perfromed, press the key combination you designated to the task (in the start of the record session!).
0