+ Reply to Thread
Results 1 to 2 of 2

Help deleting rows that do not contain criteria.

  1. #1
    Registered User
    Join Date
    05-06-2015
    Location
    California
    MS-Off Ver
    2007
    Posts
    1

    Help deleting rows that do not contain criteria.

    Good Afternoon,

    I have been busting my head against the wall about this all morning. I have attached the table below.

    This is table was tracking an item using an "ID" as seen in the first column as RecID... Now not all of these rows will have a statement that says "TRUE"

    I want to remove all the rows that do not have the word "TRUE" listed anywhere.

    Any help would be appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Help deleting rows that do not contain criteria.

    You can probably do it with VBA

    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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. VBA- deleting rows which contain cells that meet criteria, but skip alpha rows
    By cheapkid1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2012, 08:49 AM
  2. Deleting rows below once a certain criteria is met
    By alexwgordon in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-24-2011, 03:48 PM
  3. Replies: 3
    Last Post: 11-13-2009, 12:05 PM
  4. [SOLVED] Deleting rows with a two criteria
    By JOUIOUI in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2006, 08:15 AM
  5. Deleting rows by criteria
    By robertjtucker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2005, 07: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