PDA

View Full Version : [SOLVED] Filter Data, Delete Rows, Then remove filter



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!

StevenVB
08-22-2014, 01:20 AM
Hi Zlerp, see if this is what you're looking for.

Zlerp
08-22-2014, 08:23 AM
Looks Perfect!! Thank you very much for your help! I greatly appreciate it!