Autofilter Help Filtering Multiple Values in one column and applying filter in another colum

[jamesdean1379]

So I am trying to add a code to a macro to filter out 2 values in one column and add another filter to another column to filter out a couple of values. I do not get any errors when running the code, but it returns with everything filtered out instead of the values I put in the code.

 With Sheets("Inventory")

    If .FilterMode = True Then .ShowAllData

    .Range("J1").AutoFilter 10, "Customer Pick Up *", xlOr, "HOLD AT PORT  *"
    .Range("AI1").AutoFilter 10, "HOLD @ PORT *", xlOr, "HOLD AT PORT *"
    
    End With

What I am trying to do is filter out Customer Pick Up and HOLD AT PORT(this one will sometimes have a space at the end) in column J1 so they do not show up and then in column AI filtering out HOLD @ PORT and HOLD AT PORT so they do not show as well. Any insights on what I did wrong and how to correct or a better way to accomplish this?

 

[jamesdean1379]

Got it figured out!

 

[Fluff]

Glad to hear you got the solution.

If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.

 

[jamesdean1379]

Sorry about that, so the solution was to just have them deleted. Not technically a solution, but after relooking at the data and where it was going I realized that I did not need to keep that data at all so I just added a code to delete the data.