Good morning all,
Hopefully this should be quite a simple one to help me with. I have the below code on my worksheet to auto sort column A (excluding a1 as its a header) into a-z order when i add a new entry, but i want to change what triggers it. So basically i want a2:a500 to be sorted in a-z order whenever i make a change to a cell in range D2:D500.
Code
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
Range("A1").Sort Key1:=Range("A2"), _
Order1:=xlAscending, Header:=xlYes, _
OrderCustom:=1, MatchCase:=False, _
Orientation:=xlTopToBottom
End Sub
Any help would be great!
Kind regards,
Joe