+ Reply to Thread
Results 1 to 5 of 5

How to find value in column, then delete multiple rows from that row

  1. #1
    Registered User
    Join Date
    03-25-2013
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    61

    How to find value in column, then delete multiple rows from that row

    Sorry, I have zero knowledge or skill with VBA! Sometimes I can manage to cobble together what I need in a macro, but this time I'm stumped... it should be extremely simple, but I just don't know the syntax well enough.

    Here's what I need to do:

    Part 1
    1. Search for the value "99" only in column A
    2. Whenever a value is located, delete that row AND the next 5 rows.
    3. Search for the next occurrence of "99" and repeat until end of column A

    Part 2
    1. Search for the value "developing" in column C
    2. If found, check if the value "integrating" appears in the cell beneath
    3. If "integrating" does not appear then [code X]
    4. If "integrating" does appear then [code Y]
    5. Search for next occurrence of "developing" and repeat until end of column C


    Part 1 is a higher priority, as I think I can figure out Part 2 on my own with enough time.

    Thanks in advance!

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: How to find value in column, then delete multiple rows from that row

    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: How to find value in column, then delete multiple rows from that row

    here is part 2

    What is code x and code y?

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    03-25-2013
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    61

    Re: How to find value in column, then delete multiple rows from that row

    Thanks! These both work wonderfully! Code X and code Y are just two different copy-and-paste instructions, so if "Integrating" appears it will paste one thing, and if it does not appear it will paste something else.

    Thanks again!

  5. #5
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: How to find value in column, then delete multiple rows from that row

    You are welcome. Please mark the thread as solved and click on reputation if you like

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Delete multiple rows after find?
    By wattmhite in forum Excel General
    Replies: 4
    Last Post: 05-13-2014, 12:36 PM
  2. Find a value in a column and delete the 10 rows after
    By ExcelJET in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-21-2012, 02:05 PM
  3. Multiple find (and delete) non-continuous rows
    By Mattski in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2012, 09:27 AM
  4. Find then Delete rows from multiple sheets?
    By gronnies in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-19-2010, 07:07 PM
  5. Find and Delete multiple rows
    By Crockett in forum Excel General
    Replies: 3
    Last Post: 04-03-2007, 05:38 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