Can i set a formula for sorting in excel.

shan_asa 7 Posts Sunday October 29, 2017Registration date December 5, 2017 Last seen - Dec 5, 2017 at 03:53 AM - Latest reply: ac3mark 8371 Posts Monday June 3, 2013Registration dateModeratorStatus December 15, 2017 Last seen
- 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?
See more 

3 replies

Reply to this topic
ac3mark 8371 Posts Monday June 3, 2013Registration dateModeratorStatus December 15, 2017 Last seen - Dec 5, 2017 at 05:10 PM
0
Helpful
2
Yes, it is possible.

Here is an example of what it looks like:

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

shan_asa 7 Posts Sunday October 29, 2017Registration date December 5, 2017 Last seen - 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.
ac3mark 8371 Posts Monday June 3, 2013Registration dateModeratorStatus December 15, 2017 Last seen - 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!).
Respond to ac3mark