Hi guys
I have a copy macro that I use as a button to copy a set of data to another worksheet :
Sub copy()
'
' copy Macro
' copy data to partitioned bias work sheet
'
'
Range("A1:F303").Select
Selection.copy
Sheets("Sheet1").Select
Range("A1").Select
ActiveSheet.Paste
End Sub
I would like to put in a function that will delete all rows that that have values greater than set amounts
ie I would like to remove the row with the two cells highlighted in yellow at the moment I am using conditional formatting to highlight them and doing it manually but i would like to attach it to my copy button above.
Your help is appreciated 
Josh
ex.jpg
Bookmarks