+ Reply to Thread
Results 1 to 3 of 3

Delete rows if criteria matched

  1. 01-17-2019, 09:31 PM #1
    shrubfact
    shrubfact is offline
    Forum Contributor
    Join Date
    03-12-2014
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    138

    Delete rows if criteria matched

    Hi
    I am after the code to delete the entire row if in column s it says pp
    All help appreciated
    Reply With QuoteRegister To Reply
  2. 01-17-2019, 09:32 PM #2
    teylyn
    teylyn is offline
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Delete rows if criteria matched

    There must be hundreds of examples for this in this forum alone. Have you even tried to search?
    Microsoft MVP
    http://www.teylyn.com
    Twitter: http://twitter.com/IngeborgNZ
    Reply With QuoteRegister To Reply
  3. 01-18-2019, 06:25 AM #3
    shrubfact
    shrubfact is offline
    Forum Contributor
    Join Date
    03-12-2014
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    138
    Quote Originally Posted by teylyn View Post
    There must be hundreds of examples for this in this forum alone. Have you even tried to search?
    Im sure you could say that about alot of the questions asked...thanks for you input
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 1 Criteria when matched to display multiple rows of result
    By Heena Suleman in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-07-2017, 09:03 AM
  2. Delete All Rows Below Criteria in Col A / Then Delete Specific Rows in Col E
    By LennyC91 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2016, 08:22 AM
  3. How to sum multiple rows horizontally with the matched criteria
    By Cute_Petals in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-15-2013, 01:21 PM
  4. [SOLVED] how to delete delete rows with criteria and keeping formula
    By Bremmah in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2013, 07:09 AM
  5. [SOLVED] Search multiple sheets for criteria and paste all matched rows in new sheet
    By BertLady56 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-14-2012, 01:09 PM
  6. Delete Columns if Criteria matched.
    By JapanDave in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-20-2011, 07:38 AM
  7. Excel 2007 : Copying rows from one sheet to another based on matched criteria
    By hugheydarryl in forum Excel General
    Replies: 0
    Last Post: 07-21-2010, 07:12 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1