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
Bookmarks