Results 1 to 6 of 6

if cell contains <> specific word, then delete others rows

Threaded View

jagadeesh.rt if cell contains <> specific... 05-05-2019, 11:15 PM
BadlySpelledBuoy Re: if cell contains <>... 05-06-2019, 01:04 AM
jagadeesh.rt Re: if cell contains <>... 05-06-2019, 04:45 AM
Trebor76 Re: if cell contains <>... 05-06-2019, 01:14 AM
Sintek Re: if cell contains <>... 05-06-2019, 02:40 AM
BadlySpelledBuoy Re: if cell contains <>... 05-06-2019, 05:00 AM
  1. #1
    Forum Contributor
    Join Date
    08-29-2012
    Location
    Hyderbad
    MS-Off Ver
    Excel 2003
    Posts
    123

    if cell contains <> specific word, then delete others rows

        Sub specificwordInsetence()
        Last = Cells(Rows.Count, "c").End(xlUp).Row
        For i = Last To 1 Step -1
            If (Cells(i, "c").Value) <> "*deferred*" And (Cells(i, "c").Value) <> "*future*" _
            And (Cells(i, "c").Value) <> "*tax*" Then
                Cells(i, "c").EntireRow.Delete
            End If
        
        Next i
        Cells(1, 4).Select
        Application.ScreenUpdating = True
    End Sub
    List of strings : Bold String should be remain and other strings should delete by 1 step -1

    Interests in Leasehold Land Held for Own Use under Operating Leases
    Intangible Assets
    Goodwill
    Interest in an Associate, Net
    Prepayment for Acquisition of an Intangible Asset
    Available-For-Sale Financial Asset
    Financial Asset At Fair Value through Profit or Loss
    Deferred Tax Assets
    Current Assets
    Current Assets
    Inventories
    Trade and Other Receivables
    Pledged Bank Deposits
    Cash and Cash Equivalents
    Current Liabilities
    Current tax Liabilities
    Contract Liabilities
    Trade and Other Payables
    Bank and Other Borrowings
    Financial Liabilities At Fair Value through Profit or Loss
    Current Taxation
    future income tax liabilities
    Current Assets
    Net Current Liabilities
    Non-Current Assets
    Total Assets
    Non-Current Liabilities
    Total Assets Less Current Liabilities
    Non-Current Liabilities
    Other Borrowings
    Financial Liabilities At Fair Value through Profit or Loss
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Delete all rows in which column does not contain specific word
    By BVT3030 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-22-2015, 12:57 AM
  2. Delete rows that do no contain a specific word
    By Tesseh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-15-2014, 02:08 AM
  3. [SOLVED] delete rows when column has specific word(s)
    By chrisblackman in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 09-22-2013, 10:21 PM
  4. [SOLVED] Macro to delete rows that DO NOT contain specific word
    By enfieldsteve in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-19-2013, 10:59 AM
  5. [SOLVED] Need a macro to delete rows with specific word
    By renjithvakkayil in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-07-2013, 12:54 PM
  6. Delete all rows that dont contain a specific word.
    By BPSJACK in forum Excel General
    Replies: 4
    Last Post: 03-15-2012, 05:05 AM
  7. Macro to look for a specific word and delete rows
    By excelaspire0219 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-27-2009, 06:35 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1