Dynamic Filter in Excel – Filter As You Type (with & without VBA)

Dynamic Filter in Excel – Filter As You Type (with & without VBA)

In this video, I will show you how to create a dynamic filter in Excel (where you can filter as you type in Excel).

I cover two methods to create this dynamic filter:
1. Using the FILTER function – available for Office 365 Users only (0:40)
2. Using a Simple VBA code to create the dynamic filter (7:40)

Get Office 365 – https://microsoft.msafflnk.net/Vk9OR

Download the Dynamic Filter Example workbook – http://bit.ly/2wuS1Vz

Video on using Filter Function in Excel – https://youtu.be/V-T_7VwW5Y8

VBA code to filter as you Type:

‘Code Created by Sumit Bansal from TrumpExcel.com
Private Sub TextBox1_Change()
Application.ScreenUpdating = False
ActiveSheet.ListObjects(“Data”).Range.AutoFilter Field:=2, Criteria1:= “*” & [F1] & “*”, Operator:=xlFilterValues
Application.ScreenUpdating = True
End Sub

Free Excel Course – https://trumpexcel.com/learn-excel/
Paid Online Training – https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/

⚙️ Gear I Recommend:
Camera – https://amzn.to/3bmHko7
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic – https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting – https://amzn.to/2uxOxRv

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

Leave a Reply

Close Menu