Run this code and let me know
Regards,
Mandeep baluja
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Rownum As Long:
Dim colnum As Long:
Dim Temp As Long: Temp = 4
Dim lastentry As Long
With ActiveSheet
For colnum = 2 To 6
If colnum = 3 Or colnum = 6 Then
Dear All
Here I want VBA code for sorting Positive & Negative numbers (%)
Criteria Match like: J to P Column Collect all cell Positive growth (%)
J to P Column Collect all cell Negative growth (%)
If I click Positive tab then all positive growth rows sort one click, same
as negative