+ Reply to Thread
Results 1 to 3 of 3

Delete Rows without text in a Cell

  1. #1
    Forum Contributor NewYears1978's Avatar
    Join Date
    03-15-2010
    Location
    Forney, TX
    MS-Off Ver
    Excel 2016
    Posts
    962

    Delete Rows without text in a Cell

    Hey all - your favorite person lol.

    I am wanting to delete all rows where a specific text is NOT contained in Column K. I have nearly 10,000 lines so whatever the most efficient way to do this would be preferred.

    I want to work this out before I take it to the next step which will be to have a check box for first run, that when it is run the first time it asks the user their name and then saves that as the string to use for the above delete rows not containing text.
    I will probably make a data list of Names (It's for sales reps here) so that it can be edited if people are lost from the company, that on first run the list pops up and has you check your name in the list or something..but that's not required at first.
    I will work that out after (unless someone is really bored LOL)

    Thanks in advance as always! This place is always so helpful

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,523

    Re: Delete Rows without text in a Cell

    Here is a very fast code
    Please Login or Register  to view this content.
    Another fast way would be to just sort the sheet, blanks will always end up at the bottom.

  3. #3
    Forum Contributor NewYears1978's Avatar
    Join Date
    03-15-2010
    Location
    Forney, TX
    MS-Off Ver
    Excel 2016
    Posts
    962

    Re: Delete Rows without text in a Cell

    There are no blanks, the cells contain names of sales reps and I need to remove all the ones that don't contain my name.

    But your post gave me a solution, filter by my name, then remove hidden rows with vba

+ 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. [SOLVED] Delete the rows if a cell does not contain certain text
    By roskalov in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-26-2017, 10:48 AM
  2. [SOLVED] VBA to delete rows if certain text exist in cell & fill with formula
    By johnmacpro in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-29-2016, 05:46 PM
  3. How to delete rows that contain certain text in a cell using a formula
    By panchovilla1221 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-27-2014, 09:00 PM
  4. [SOLVED] Find row cell containing specific text, then delete all rows ABOVE that cell
    By ks100 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-20-2013, 02:02 PM
  5. [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
  6. Insert/delete rows or unhide/hide if cell Contains Certain text
    By ashhm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-21-2012, 08:52 AM
  7. [SOLVED] Code to delete rows that do not contain certain text in a cell
    By rwgladwin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-12-2012, 07:45 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