Autofilter Values Not in a List (Dynamic Range) | Excel VBA Macro

[@greggowaffles]

Autofilter All Values In A List 🤓😎 : kzbin.info/www/bejne/gmqlmX5secqdrpY

[@yousuresh121]

Thank you So Much. It helps Lot. Sorry for late reply

[@greggowaffles]

No problem. So glad to hear that!

[@NagaRaju-kl6ds]

Excellent explanation

[@stohajunwa]

Thanks, a lot. This has solved my problem!

[@entuella]

A lifesaver! Thanks a lot!

[@greggowaffles]

No problem! Thanks for watching!!

[@Virusinsides]

Thank you for teaching us your knowledge, very good tutorial, thanks

[@greggowaffles]

Really appreciate that. Thanks for watching!

[@drewgossage8842]

Another great upload, thanks man👍👍

[@greggowaffles]

Appreciate you! 💪💪

[@sirajkhan6945]

You are awesome brother ❤

[@greggowaffles]

Thank you!!

[@biapositive]

Helpp.. What if I have a do not include list for 2 columns.. What will be the range? I'm just new with macro so I am not sure what to do.. Help me

[@NagaRaju-kl6ds]

Thanks, I learn from this video for how to filter, I have one requirement A B C D IT Companies Employees Salary EMP ID Wipro Ajay 10524 L1201 Infosys Bhupathi 25874 L8542 HCL Mishra 36974 K2314 HCL Akash 15974 M1423 KPIT James 56478 L7452 Wipro Rahul 36125 L8547 NIIT Alok 52314 L7452 My requirement is in D column we need match with L1201, L7452, L8547, L1814, L2770 data. if anything else ex:K2314 needs to show error. I have written code like this for filter is working objExcel.Worksheets(1).cells(1,4).autofilter 4, Array("L1201", "L7452", "L8547", "L1814", "L2770"), 7. Please help above requirement. send code