Hi

I Need Help Vba Code Automatically Sort Rows Largest To Smallest IF Cell G > 50% And Cell D > 1%

Have you tried using the Record Macro feature in VBA? This feature will record the code when you are working in the Excel environment. You then stop recording and go view the code in the code editor.

I need edit this code work automatically


Sub sort()
'
' sort Macro
Selection.sort Key1:=Range("N7"), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

End Sub

can help me