keep column d is greter than column b data and column d is lower than column j data and delete rest

[Leonardo1234]

keep column d is greater than column b data and column d is lower than column j data and delete rest data

 

[Belleke]

see attached

 

[Leonardo1234]

Thnx Belleke for giving ur precious time and great support to this post
Problem Solved

 

[Leonardo1234]

Private Sub CommandButton1_Click()
Dim i As Long
    For i = Cells(Rows.Count, 4).End(xlUp).Row To 2 Step -1
        If Cells(i, 4) <= Cells(i, 2) And Cells(i, 4) >= Cells(i, 10) Then Cells(i, 2).EntireRow.Delete
    Next

End Sub

u have used this code and a button
but in my file i am not using button so changes are required
plz change and modify the code plz mentioned the target sheet in the code

 

[Luke M]

@Leonardo1234

Please do not make multiple posts about the same question. Stick to your original thread.

https://chandoo.org/forum/threads/if-column-c-equal-to-d-then-delete-that-row.39527/