Zlerp
08-21-2014, 01:09 PM
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
12171
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!
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
12171
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!