Hi I adapted a macro to help me sort data - it searches for a value in the rows and any rows in that worksheet, it copys them to another worksheet called "results" and then deletes the original row:
Sub CutandPasteRows()
Dim rng As Range
Dim rng2 As Range
Dim cl As Range...