Results 1 to 8 of 8

loop multiple criteria & delete matching rows?

Threaded View

  1. #1
    Registered User
    Join Date
    11-14-2013
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    96

    loop multiple criteria & delete matching rows?

    Morning All,

    Attached is a simplified spreadsheet with my intentions... ive had no luck with initiating something remotely close to achieving this and would like some assistance.
    Objective: If the highlighted criteria from sheet2 matches the corresponding columns in sheet1, remove that entire row.

    In my head its a simple objective but the two potential loops are throwing me off.

    Thanks!
    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] Objective: delete rows based on multiple criteria matching
    By Quint6778 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2017, 05:25 PM
  2. [SOLVED] DELETE Rows in SQL db table matching criteria via EXCEL VBA
    By carsto in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-10-2016, 07:03 PM
  3. Macro to delete rows based on two different criteria matching
    By Cpower17 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-25-2014, 05:43 PM
  4. Loop through rows and delete based on criteria
    By yolandaro30 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-27-2012, 12:23 PM
  5. Within a loop, need to copy all rows from one sheet to another upon matching criteria
    By ripvanbrown in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-17-2012, 03:52 PM
  6. [SOLVED] Mark or Delete Rows based on Matching Multiple Criteria in another worksheet
    By clearbluez in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2012, 02:38 PM
  7. delete rows not matching certain criteria
    By sanketgroup in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2011, 04:04 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