+ Reply to Thread
Results 1 to 3 of 3

Find row cell containing specific text, then delete all rows ABOVE that cell

  1. #1
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    298

    Find row cell containing specific text, then delete all rows ABOVE that cell

    Need to:

    1: Find cell containing specific text "description info" (will for sure be in first 10 rows of worksheet).
    2: After that cell is identified, count the number of rows above it:

    IF more than 10 rows above it, then display warning:
    "my warning message"

    IF clicked OK
    THEN delete rows above identified cell

    IF clicked cancel
    THEN end sub
    Last edited by ks100; 12-20-2013 at 02:03 PM.

  2. #2
    Forum Contributor vamosj's Avatar
    Join Date
    04-23-2004
    Location
    Oregon
    MS-Off Ver
    2010
    Posts
    294

    Re: Find row cell containing specific text, then delete all rows ABOVE that cell

    This would have to be done with a Macro as no Formula would be able to delete rows.

    Please post in the VBA forum.
    Janos S. Vamos
    Data Systems Technician/Fire Controlman PO1(SW/AW)
    US Navy Retired


    Remember, Record Macro can be your friend for figuring out solutions.

    Good or Bad, let me know how I did by clicking on the "Add Reputation" * just to the lower left of here. it only takes a few seconds to let someone know.

  3. #3
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    298

    Re: Find row cell containing specific text, then delete all rows ABOVE that cell

    Quote Originally Posted by vamosj View Post
    This would have to be done with a Macro as no Formula would be able to delete rows.

    Please post in the VBA forum.
    Meant to post there, hit wrong forum, sorry.

+ 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. Replies: 2
    Last Post: 08-05-2013, 07:32 PM
  2. Find the row a specific text is in a data set & delete certain rows
    By bcn1988 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-29-2013, 03:52 PM
  3. [SOLVED] delete rows that do not contain the text from a specific cell
    By Vogelmann in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-11-2012, 03:10 AM
  4. [SOLVED] Macro to find specific text in a cell and then create multiple rows above
    By Willardio in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-21-2012, 09:52 AM
  5. Replies: 4
    Last Post: 09-18-2012, 10:54 AM

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