Delete rows if specific criteria not met.

I have a spreadsheet with 8 columns. I want to delete all rows that don't
have the text "Remittance" in column B. I would like to put the code in an
existing macro. Is this very difficult? Thanks

Try

Dim LastRow As Long
Dim RowNdx As Long
LastRow = Cells(Rows.Count, "B").End(xlUp).Row
For RowNdx = LastRow To 1 Step -1
If Cells(RowNdx, "B") <> "Remittance" Then
Rows(RowNdx).Delete
End If
Next RowNdx


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"SITCFanTN" <SITCFanTN@discussions.microsoft.com> wrote in
message
news:DEE4F15A-6E83-4285-BBE5-8646699B2D4C@microsoft.com...
>I have a spreadsheet with 8 columns. I want to delete all rows
>that don't
> have the text "Remittance" in column B. I would like to put
> the code in an
> existing macro. Is this very difficult? Thanks

One way:

Sub test()
Const strCriteria As String = "remittance"
Dim rngData As Range
Dim rngCell As Range
Dim rngDelete As Range

With Worksheets("Sheet1") '<<<<<Change
Set rngData = Intersect(.UsedRange, .Columns(2))
End With

For Each rngCell In rngData
If LCase(rngCell.Value) <> LCase(strCriteria) Then
If rngDelete Is Nothing Then
Set rngDelete = rngCell
Else: Set rngDelete = Union(rngDelete, rngCell)
End If
End If
Next rngCell

If Not rngDelete Is Nothing Then _
rngDelete.EntireRow.Delete

End Sub


"SITCFanTN" wrote:

> I have a spreadsheet with 8 columns. I want to delete all rows that don't
> have the text "Remittance" in column B. I would like to put the code in an
> existing macro. Is this very difficult? Thanks

I've done this but don't have the code at home. If you haven't gotten an
answer by tomorrow, I'll copy what I have then.

"SITCFanTN" <SITCFanTN@discussions.microsoft.com> wrote in message
news:DEE4F15A-6E83-4285-BBE5-8646699B2D4C@microsoft.com...
>I have a spreadsheet with 8 columns. I want to delete all rows that don't
> have the text "Remittance" in column B. I would like to put the code in
> an
> existing macro. Is this very difficult? Thanks