Autofilter Three Or More Not Equal To Criteria (In Same Column) | Excel VBA Macro

[@olabanjiolaniyan7066]

New Vid! Ayeeee!

[@greggowaffles]

Ayyeee!! Appreciate the love bro!

[@Thor_Underdunk_Caballerial]

What a fantastic tutorial, massive help. I'm surprised this has so few views, but I'm sure it will help countless people in the coming years, or at least until Microsoft implement this functionality within filters. Until then, it's GreggoWaffleStomp time.

[@greggowaffles]

Haha thanks!! Glad it helped!!

[@timkropf4648]

Nice content! I've watched several of your AutoFilter tutorials as they went right to various things I was trying to accomplish. To not have the color flash when the macro runs, I think one could add this at the beginning of the code: "Application.ScreenUpdating = False" and then run this at the end of the code: "Application.ScreenUpdating=True". This works for me in a lot of code, but I haven't tried your example to prove it doesn't have an issue somewhere.

[@greggowaffles]

Thanks! Yeah, that would do the trick!!

[@Arven501]

Thank you thank you! adding this to my toolbox for sure!

[@greggowaffles]

No prob! 🛠️🧰

[@redhaakhund1271]

Amazing video. So much to learn from you sir. Wish you all the best

[@greggowaffles]

thanks a lot! same to you!!

[@biapositive]

What would be the code if we do the same process but it involves 2 column and those two columns need to exclude specific data? Hope you can help

[@JonasOlssen008]

FABULOUS! EXACTLY WHAT i NEEDED.

[@greggowaffles]

So glad to hear that!!

[@JonasOlssen008]

@@greggowaffles Mate, you're a legend. I have one that almost broke me. I need to do a vlookup against a dynamic cell reference, to identify the corresponding value in another worksheet. Nothing I try works. So the code identifies when the position of the lookup reference cell changes and you would think that you can simply tell the program to go find the value, but no. It keeps looking for the cell reference as a string. So I call this cell reference apple. Vlookup(apple,Analysis,$A:$B,2,0) I'll bet I kick myself when you report it as something simple. Nobody on google had a viable solution. The video you posted saved me hours of pain and so far you are the only one that had a viable solution which works 100% of the time. I had an issue with the loop, but I took care of that lad with on error resume next. Hope you can help.

[@greggowaffles]

Thanks! I hope I understand this correctly: you want to find the value, Apple, as it moves around on another tab and grab the cell to the right of it?

[@JonasOlssen008]

@@greggowaffles Hey, nono. Let me articulate. Sheet one contains apple sales data. Sheet 2 contains the list of apples with their product codes. Current VBA code identifies which apples need to be investigated from sheet 2. Lets say this month its in cell E45, next month it could be in cell E1255. Under normal circumstances, its dead easy, vlookup(E54,'Prodlist!A:B,2,0) But the key to this problem is that the location of the apple that needs to be investigated is always unknown and the integrity of the sales data needs to remain completely untouched for apples that do not need to be investigated. So this time I hard coded it to E45. But that will cause a failure next month because the row reference would be incorrect (the column reference is always the same). The code captures the address of the cell that refers to the code (and apple) that needs to be investigated. But trying to vlookup that dynamic address/cell reference has proven to be quite the bugger! Makes sense now? So that was why I used apple in my example. I declared the dynamic cell reference as a variable and of course, called it apple..

[@greggowaffles]

Thanks! Makes a lot more sense. So is the output cell: =vlookup(E54 or E1255 or whatever, Prodlist!A:B,2,0) always going to be in the same location?

[@kit3146]

Great one, can you teach how to apply the same logic to other sheets? Assume that we have the same data format in other sheets. Thanks a lot! Wish you all the best

[@yeahitsmusic]

Woah this is amazing! Thank you so much for this!

[@greggowaffles]

No problem! Thank you for watching!!

[@chrissoraghan8976]

very clever. works a treat. well done and thanks!

[@greggowaffles]

Thanks! 😎

[@wfemp_4730]

FYI, the variable "count" is defaulting to the variant data type, not long.

[@greggowaffles]

Thanks! I know that now. Didn’t know that when I actually made the video

[@ФилиппИванов-щ7д]

Молодцом 👍

[@ayaabdelwahab7706]

cool stuff! Thanks for sharing! :)

[@greggowaffles]

Thanks for watching!! 😊

[@Dexter101x]

Don't you ever name your modules? This will make you having to search for a long time where a particular macro is

[@greggowaffles]

Yeah, that’s a good point. I haven’t named them in any video 😅😅