Results 1 to 18 of 18

Excel VBA to Delete rows based on multiple criterias

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-20-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    275

    Excel VBA to Delete rows based on multiple criterias

    Dear all,
    Plz review the attached excel file.
    I have nearly 200 rows in column A:A.
    Among this, I need to keep few rows and delete others. My original file is exactly in the same format of attached file.
    I want VBA code to delete all the rows between different criterias as mentioned.

    Please note:I want cells with criteria values also to be deleted.
    Overall,after I run the macro,only rows with "Must not be deleted" must be retained.

    Plz don't waste your time in writing code in reverse way (Cells with "Must not be deleted" must remain)
    I need a code to key-in my criteria.

    Thanks for all your support.

    Madvesh
    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. delete rows based on three criterias
    By cbk40060 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-15-2015, 02:26 PM
  2. Hide Rows based on multiple criterias
    By Dahlia in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-02-2014, 04:47 AM
  3. [SOLVED] Delete rows based on multiple criterias, copy/paste data and formulas
    By BQuek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-24-2013, 01:36 PM
  4. Delete entire row based on criterias in range?
    By drdavidge in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2008, 02:28 PM
  5. Delete rows based on multiple criterias
    By Benson in forum Excel General
    Replies: 8
    Last Post: 11-02-2005, 06:17 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1