Consulting

Results 1 to 3 of 3

Thread: Filter Data, Delete Rows, Then remove filter

  1. #1
    VBAX Regular
    Joined
    Aug 2014
    Posts
    49
    Location

    Filter Data, Delete Rows, Then remove filter

    Hello All,

    I am looking for help with a Macro.

    What I want is for the Macro to put a filter on Column U and Delete any row that does NOT have the one of the vlaues below in column U:
    RAN OCR
    RAN OCR PROCESS
    (Blanks)


    PS: (Blanks) = Empty Cell

    i also want to keep the first row. the Value for U1 = "OCR"

    Example:

    Filter of Column U
    RAN OCR.jpg

    in the Image above i would want to delete all the rows that containt the values "Document Printed Incorrectly" and "Erroneous Document-Incorrect" in column U.

    I want to keep all the other rows of Data.

    The Data in column U will always contain at least one of these three names shown below. Anything else needs to have the row deleted.
    RAN OCR
    RAN OCR PROCESS
    (Blanks)

    Let me know if you have any questions! Thanks for your help!
    Last edited by Zlerp; 08-21-2014 at 01:24 PM.

  2. #2
    VBAX Newbie
    Joined
    Aug 2014
    Posts
    4
    Location
    Hi Zlerp, see if this is what you're looking for.
    Attached Files Attached Files

  3. #3
    VBAX Regular
    Joined
    Aug 2014
    Posts
    49
    Location
    Looks Perfect!! Thank you very much for your help! I greatly appreciate it!

Posting Permissions

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