How to automate Advanced Filter with VBA to search data automatically

Suppose you need to create a system to search data in an Excel Table using different criteria for the various fields. In that case, Advanced Filter can be one good solution for you, especially if you do not have access to the Microsoft365 version of Excel with the FILTER function.

This video will teach you how to automate the Advanced Filter tool to work immediately after changing a search criteria value.

----------------------

Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer



Twitter: @celia_excel

Instagram: @solveandexcel


#excel #msexcel #powerquery #dataanalysis #snapreports #solveandexcel #automation #reportautomation #VBA

-------------------------

#Excel #shorts #solveandexcel #microsoft365 #toronto #torontobusiness #wit #msexcel #microsoftexcel #excelreport #excelautomation #snapreports #powerquery #canada

[alayoubi]

very good thnx
i would like to asking you
if i have many sheets like all month's
and i want to filtering data from any one sheet
depending on the name of employee and month
what the excel equation i can do ??
thnx y

[bigguy]

Thanks forf this video. You explained the process for automating the execution of the Advanced Filter very well. Although my prior knowledge of Visual Basic was very helpful to understand how the macro code was automatically generated, without this video I would not have been able to figure out the additonal code to be written to control what area of the worksheet to monitor for changes so that the macro automatically runs. Great job!! Liked and Subscribed!

[carlodamalerio]

Very well explained. Exactly what im looking for. Only thing is i don't want results if the criteria is empty

[semihsolmaz]

Can I make a special request? How to get the result when filtering only with Blue?