Can i set a formula for sorting in excel.

Closed
Report
Posts
7
Registration date
Sunday October 29, 2017
Status
Member
Last seen
December 5, 2017
-
 Blocked Profile -
Hello,

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

1 reply


Yes, it is possible.

Here is an example of what it looks like:

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

Posts
7
Registration date
Sunday October 29, 2017
Status
Member
Last seen
December 5, 2017

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.
Blocked Profile
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!).