Largest to smallest or vice versa

[Kalsefar]

Hello,

 

I need VBA code to sort data automatically from largest to smallest or vice versa.

[Kalsefar]

6 hours ago, Kalsefar said:

Hello,

 

I need VBA code to sort data automatically from largest to smallest or vice versa.

 

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    If Target.Column = 2 Then
        
        Dim lastrow As Long
        lastrow = Cells(Rows.Count, 2).End(xlUp).Row
        Range("B2:C" & lastrow).Sort key1:=Range("B2:B" & lastrow), order1:=xlAscending, Header:=xlNo
        
    
    End If
    
End Sub

 

This is the code if someone needs it in the future.