Results 1 to 26 of 26

Find keyword and delete the rows below and above

Threaded View

zeroist Find keyword and delete the... 09-09-2013, 08:34 AM
patel45 Re: Find keyword and delete... 09-09-2013, 09:43 AM
zeroist Re: Find keyword and delete... 09-09-2013, 05:41 PM
patel45 Re: Find keyword and delete... 09-10-2013, 02:46 AM
HaHoBe Re: Find keyword and delete... 09-10-2013, 02:52 AM
HaHoBe Re: Find keyword and delete... 09-10-2013, 03:40 AM
zeroist Re: Find keyword and delete... 09-10-2013, 08:18 AM
zeroist Re: Find keyword and delete... 09-10-2013, 05:21 PM
HaHoBe Re: Find keyword and delete... 09-11-2013, 07:09 AM
zeroist Re: Find keyword and delete... 09-11-2013, 06:43 AM
zeroist Re: Find keyword and delete... 09-11-2013, 08:20 AM
HaHoBe Re: Find keyword and delete... 09-11-2013, 09:01 AM
zeroist Re: Find keyword and delete... 09-11-2013, 09:38 AM
HaHoBe Re: Find keyword and delete... 09-11-2013, 09:46 AM
zeroist Re: Find keyword and delete... 09-12-2013, 02:27 AM
HaHoBe Re: Find keyword and delete... 09-12-2013, 02:44 AM
zeroist Re: Find keyword and delete... 09-12-2013, 10:18 AM
HaHoBe Re: Find keyword and delete... 09-12-2013, 10:29 AM
zeroist Re: Find keyword and delete... 09-12-2013, 12:55 PM
HaHoBe Re: Find keyword and delete... 09-12-2013, 01:58 PM
zeroist Re: Find keyword and delete... 09-12-2013, 02:54 PM
zeroist Re: Find keyword and delete... 09-12-2013, 03:16 PM
HaHoBe Re: Find keyword and delete... 09-12-2013, 03:54 PM
zeroist Re: Find keyword and delete... 09-13-2013, 03:04 AM
HaHoBe Re: Find keyword and delete... 09-13-2013, 03:35 AM
zeroist Re: Find keyword and delete... 09-13-2013, 03:45 AM
  1. #1
    Registered User
    Join Date
    09-05-2012
    Location
    Türkiye
    MS-Off Ver
    Excel 2013
    Posts
    80

    Find keyword and delete the rows below and above

    my request was changed as in 7th post
    first part:
    firts I want to find a specific word and the delete the rows above the row including found keyword.
    In the sample find "there is no guarentee" then delete the rows (row numbers:4-3-2-1) (there is "there is no guarentee" 2 TIMES BUT THE FIRST ONE)

    second part

    I want to find a specific word and the delete the rows BELOW the row including found keyword.
    In the sample find "ringtone to your cell" then delete the rows (row numbers:35-36-37...)) (there is "ringtone to your cell" 2 TIMES BUT THE LAST ONE)

    This macro should work for all sheet in workbook.

    before.xlsx
    after.xlsx
    Last edited by zeroist; 09-11-2013 at 03:16 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 03-18-2014, 11:16 AM
  2. Macro To Find & Copy Rows Based On A Keyword List
    By Lilfish in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-02-2013, 10:02 AM
  3. Replies: 4
    Last Post: 09-18-2012, 10:54 AM
  4. Replies: 2
    Last Post: 07-13-2012, 04:02 AM
  5. VBA Popup to search a sheet and delete rows based on keyword entered
    By MichaelJG in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-05-2011, 08:08 AM

Tags for this Thread

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