Copying Row based on text in a Cell

[Bob Folks]

Hi

I am new to this Forum but look forward to many productive hours here.

I was hoping someone could help me I recuire a Macro to look at data from a Data Dump and cut the whole row and paste it onto a new sheet when the cell of that row in column "K" = [TBS]. I sure this can be done but I just cant work it out.

Any Assistance would be greatfullt apretiated.

Cheers

Bob

 

[Michael M]

Maybe this

Sub MM1()
With Columns("K")
    .AutoFilter field:=1, Criteria1:="[TBS]"
    .Resize(Rows.Count - 1).EntireRow.Copy Destination:=Sheets("TBS").Range("A1")
    .AutoFilter
End With
End Sub

 

[Bob Folks]

You guys are legends thankyou so much you have saved what little hair I have left.