Delete rows based on lower value than number specified , positive or negative values

Hey guys

I am trying to find a solution to my problem but I think I'd need someone with a bit more brains than me :P I am trying to delete rows based on the value of four columns, Column Q ; R & S ; T.
But here is the catch, the values in those columns are positive and negative,and lets say my deleting criteria is : 3 then I want all rows deleted is small than 3 , that would be either -3 or +3 . So lets say the column has a -4 then I want the macro to see that the number is ''greater'' then 3 and therefor not delete it. The macro should read both positive and negative numbers if you understand what I'm saying

I'll include the a test piece of the document I am working on with this post.
About the document:

•Values I want this macro to read is located in columns Q ; R & S ; T all the way down till there is no data left ( the size of the data in my document will always be different)

•The deleted rows should be shifted up after deletion.

•The value that I want to be using for deleting criteria is +\-4 ( so that would mean anything gets deleted 'below' that number example: 3 & -4 and numbers like -5 ; -4 ; -7 will not be deleted because they have a ''higher'' number than 4)

Thanks for reading , any type of help I appreciate and value, thanks all

Yes , exactly that, Sorry if this is a stupid problem, but hoping it to be possible in macro form , since other people will be using this document to filter out data and they are not good at excel themselves. Thus making it easier if this was a written macro

Hey Disarray

I tried your code out, thanks for attacking the problem so quickly :P but the code seems to not run as smoothly, it gives me a ''Run time error '13' '' is there anything I should change in the code?

I only see your cool button feature now like it ! somewhere a link is still missing though , it does not appear to remove those rows yet..

I tried the one you inserted into my book , that one didn't work so well, and then I tried to just copy your code into a new macro, and that gave me the run error. We are almost there ! ^^ perhaps I could make you a cup of coffee while you have a brain storm about it

Here is your downloaded workbook which I have now, the button does not seem to remove any numbers lower than +/- 4

Ah, thanks. It is working, but I see now my mistake as well... the one column has only 0's in it, and sometimes that will differ, sometimes another column might have a series of zeroes in it and because that cell has zeroes it will always delete all lines regardless of the column next to it having a number greater than 4 . Is it possible to adjust it the macro that if there is a cell that has that greater number than 4 in it that it does not delete the row regardless of the cell next to it having a zero?


Turned out a bit more complicated than I first thought it would, sorry , but thanks for helping thus far.

Hi Disarray , apologize I never got back to you earlier, I just fell asleep haha . Well what you explained is exactly what I want yes,however when I tried your code it told me ''type mismatch'' >_>

I think there is something strange happening here, because even though it is working for you, on the workbook that you last posted, if I run the macro from the view macro list then it deletes all the data because of the zeroes... I'll post my original workbook for you now, you can have a look.

Go to the last worksheet called ''Raw Data''
Hope we get this funny business sorted, you are pretty funny when I get you confused :P Maybe I'm just not that good at explaining >_> or lets rather blame it all on the workbook

Hi Disarray, thanks for your patience with this one, okay, to clarify the delete conditions: if the value within any of the two columns is less then 4 , the row gets deleted. That would mean -3, 3.9 ,2 , -1 all deleted & -4.1 , 4 , -7 .-8 , 5 All remain in the sheet. But lets say one column cell is 2 and the other column cell ( in the same row) is 4.2 then I'd want this row not to be deleted.

Hope that's good and clear, any question please ask, attaching my workbook I'm using right now with your latest code in, but the code still deletes everything though =(

Cheers

Okay, I did a few examples for you ^^

Attached is the workbook.