Hello all I have a code that I am trying to wright, in my code I would like to go thorough the rows and delete the entire row that does not contain the words "Filler Stock"
as of right now I can delete it but I want to change that to delete every thing but that, I have a feeling I would need to change the .value "like" to something that is not like ?
as of right now I can delete it but I want to change that to delete every thing but that, I have a feeling I would need to change the .value "like" to something that is not like ?
Code:
With Worksheets("DataDump3")
For Counter = 12 To 1 Step -1
If .Range("B" & Counter).Value Like "*Filler Stock*" Then
.Rows(Counter).EntireRow.Delete ' Delete Row
End If
Next