+ Reply to Thread
Results 1 to 6 of 6

Delete Rows Based on Condition

  1. #1
    Registered User
    Join Date
    04-05-2016
    Location
    Philadelphia, Pennsylvania
    MS-Off Ver
    Microsoft Office Professional Plus 2013
    Posts
    40

    Delete Rows Based on Condition

    Hi Everyone, I have seen many threads about this from around the web, but I can't find one which is working for me for one reason or another. I am looking to delete rows in the "Manifests" worksheet which are = TextBox1.Value in Userform3 when clicking the commandbutton in Userform 3.

    I have tried multiple options and none have seemed to work for me. Any suggestions?

    Best,
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Delete Rows Based on Condition

    Hi gxm,

    Have you tried using an Advanced Filter and the Not Criteria to reduce your rows to what you want? Read:
    https://www.excelfunctions.net/excel...ed-filter.html
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    04-05-2016
    Location
    Philadelphia, Pennsylvania
    MS-Off Ver
    Microsoft Office Professional Plus 2013
    Posts
    40

    Re: Delete Rows Based on Condition

    Hi Marvin,

    I haven't tried that, but I did look into it. It was my understanding that by using the Advanced Filters options that the rows still will not truly be deleted (just filtered). And unfortunately, for my purposes, I am looking to completely delete the rows. Please correct me if I am wrong there!

    Best,

    gxm

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,821

    Re: Delete Rows Based on Condition

    Try:
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  5. #5
    Registered User
    Join Date
    04-05-2016
    Location
    Philadelphia, Pennsylvania
    MS-Off Ver
    Microsoft Office Professional Plus 2013
    Posts
    40

    Re: Delete Rows Based on Condition

    Hey Mumps - that'll do it! Thank you!

  6. #6
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,821

    Re: Delete Rows Based on Condition

    You are very welcome.

+ 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 Rows in Excel Using VBA Based on Condition
    By mayaincaztec in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-26-2015, 09:41 AM
  2. Delete rows based on more than one condition
    By Steve2107 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 04-16-2014, 06:16 AM
  3. Macro to delete all rows based on one condition
    By vemix in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-30-2012, 05:24 AM
  4. Delete rows based on condition
    By elocin17 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2012, 12:35 PM
  5. Delete rows based on a condition
    By sakinen in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-20-2009, 09:14 AM
  6. Code to Delete Rows Based on Condition
    By Expedition in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-01-2009, 01:51 PM
  7. A loop to delete rows based on condition
    By Josh_123456 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-21-2007, 05:51 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