Results 1 to 2 of 2

Thread: VBA To Delete Rows Based On Value Criteria In A Column

  1. #1
    Banned
    Join Date
    May 2013
    Posts
    17
    Rep Power
    0

    VBA To Delete Rows Based On Value Criteria In A Column

    Hi there!

    I would just like to ask if there is a way to delete a row which contains the word "Received" and "Pending" in column I? and transfer to another worksheet within a workbook whichh has the words "CA","US","ERROR","#VALUE!","XXX","YYY","VVV"? Please help!

    Thank you in advance!

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Your first requirement is reasonably clear, although I'd still ask what do you mean by 'delete and transfer'. Does it mean to cut and paste? Or did you mean that you want to delete all rows that contain Received and Pending.

    What's the second requirement? You mean you want to move all rows that have any one of the words "CA","US","ERROR","#VALUE!","XXX","YYY","VVV" to another worksheet in the same workbook?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Delete Rows Based on Conditions
    By AbiG2009 in forum Excel Help
    Replies: 6
    Last Post: 12-26-2018, 01:24 PM
  2. Replies: 6
    Last Post: 08-14-2013, 04:25 PM
  3. Replies: 3
    Last Post: 05-23-2013, 11:17 PM
  4. Delete Remove Rows By Criteria VBA Excel
    By marreco in forum Excel Help
    Replies: 5
    Last Post: 12-20-2012, 05:56 PM
  5. Delete unwanted rows & column
    By sanjeevi888 in forum Excel Help
    Replies: 1
    Last Post: 09-30-2012, 08:52 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •