Results 1 to 18 of 18

If Cell equals certain values then search criteria and delete entire rows downwards

Threaded View

  1. 07-22-2018, 12:39 PM #1
    abhinavbinkar
    abhinavbinkar is offline
    Forum Contributor
    Join Date
    07-09-2013
    Location
    Nagpur, India
    MS-Off Ver
    Excel 2010 / 2013
    Posts
    293

    If Cell equals certain values then search criteria and delete entire rows downwards

    Hi,

    Please refer my attached file.

    If cell E1 equals to 40 or 80 Then search and delete entire rows downwards in Column A when the cell starts from letter "L".

    If cell E1 equals to 100 Then search and delete entire rows downwards in Column A when the cell starts from letter "D".

    If cell E1 Not equals to 40 or 80 or 100 Then search and delete entire rows downwards in Column A After cell starts from letter "L" (Excluding the Cells starting from letter "L").

    Pleas help.

    - Abhinav
    Attached Files Attached Files
    Last edited by abhinavbinkar; 07-22-2018 at 12:43 PM. Reason: Wrong attachment
    Reply With QuoteRegister To Reply
« 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. [SOLVED] Delete Entire rows without loop with multiple partial strings criteria
    By caabdul in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-04-2018, 12:05 PM
  2. VBA To search for Cell Value on a different sheet and delete entire row
    By Jon78p in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-02-2016, 01:15 PM
  3. Find and Delete rows based on cell value VBA, using a list as search criteria
    By ang374 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-08-2015, 10:55 AM
  4. Macro to delete entire rows if column d equals 2925-6 & abc
    By Triscia in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-14-2015, 07:50 AM
  5. Delete rows if cell value equals specific value - VBA
    By xtort81 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-14-2013, 04:31 PM
  6. Macro to delete entire rows if cell values do not match list/named range.
    By swolfe2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-17-2013, 02:13 PM
  7. delete entire rows based on a criteria
    By acekargo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-30-2008, 11:15 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