+ Reply to Thread
Results 1 to 4 of 4

Filter and Delete Rows

  1. #1
    Registered User
    Join Date
    05-29-2017
    Location
    England
    MS-Off Ver
    365
    Posts
    17

    Filter and Delete Rows

    Hi can anyone help?

    I have posted this question at
    https://www.mrexcel.com/forum/excel-...ml#post4858826

    Moderator Edit; also posted at: http://www.ozgrid.com/forum/showthread.php?t=204653

    I have hundreds of rows of data with 11 columns A:K that I need to filter (sheet1).

    I would like to first filter all the rows (A2:K) using the name in column A so all the rows for Sarah are showing and then filter all these rows using column E leaving only the rows (A2:K) that start with '0' (E:K)

    Then repeat the process for David to leave only the rows (A2:K) that start with '1'(E:K)
    Then again with Tom to leave only the rows (A2:K) that start with '-1'(E:K)
    Then again with Bethany leaving rows starting with '2'(E:K)
    And again with John leaving rows '-2'(E:K)
    And again with Katie leaving rows '3'(E:K)

    Deleting all the rows filtered out.
    Last edited by alansidman; 07-02-2017 at 07:00 PM.

  2. #2
    Registered User
    Join Date
    05-29-2017
    Location
    England
    MS-Off Ver
    365
    Posts
    17

    Re: Filter and Delete Rows

    Hi, just to let everyone know, two solutions have been offered on the other forums

    http://www.vbaexpress.com/forum/show...l=1#post364115

    or

    http://www.ozgrid.com/forum/showthre...136#post795136

    Regards

    pwill32

  3. #3
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,892

    Re: Filter and Delete Rows

    Try this :
    >Select the range that you want to delete the visible data. (Select : David / Tom / Bethany / John / Katie)
    >Click Home > Find & Select > Go To Special
    >In the Go To Special dialog box, select Visible cells only
    >Then click OK, all the visible rows have been selected in the selected range.
    >Then press Delete key on the keyboard, the selected visible values will be deleted and the hidden values will be kept. (Hidden is "Sarah")


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  4. #4
    Registered User
    Join Date
    05-29-2017
    Location
    England
    MS-Off Ver
    365
    Posts
    17

    Re: Filter and Delete Rows

    Thanks avk,

    I will give this a try

    regards

    pwill32

+ 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 with rows with filter
    By hudson andrew in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-10-2016, 04:30 PM
  2. [SOLVED] Filter and Delete Rows
    By arpanpanchal in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-06-2016, 11:20 PM
  3. Delete Rows hidden by either Auto Filter and Advanced Filter
    By lesoies in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2013, 10:29 AM
  4. [SOLVED] Filter/Delete Rows
    By ryannjohnsonn in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-17-2012, 04:14 PM
  5. Delete & Merge Columns,Delete Rows with filter, etc
    By traderindia in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-17-2009, 02:12 AM
  6. Delete Rows After a filter
    By koda86 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 11-25-2008, 05:02 AM
  7. Delete Rows After a filter
    By koda86 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-24-2008, 09:20 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