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)

00:00 Intro
00:40 Creating Dynamic Filter Using the FILTER function
07:40 Creating Dynamic Filter Using VBA

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 -    • Excel FILTER Function Explained (7 Example...  

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/trumpexc...

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial