VBA | Dynamic range Filters in Excel | Automatic filter

preview_player
Показать описание
Filters play a key role when you visualize data in MS excel. Here I am presenting a dynamic filter that refresh the results automatically as you change the value on the sheet itself.

If you don't know VBA macros or programming, even then you can follow these simple steps to create this.

Follow other suggested videos on our channel to learn more tips and tricks in excel.

Hit Like and subscribe to our channel to appreciate our efforts.
  1. Extreme Automation - Kamal Girdher
  2. vba
  3. macros
  4. excel
  5. filter
  6. filters
Рекомендации по теме
VBA | Dynamic 0:11:33

VBA | Dynamic range Filters in Excel | Automatic filter

Excel VBA Code 0:03:19

Excel VBA Code to Apply Dynamic Date Filters to an Excel Table

Excel VBA - 0:01:22

Excel VBA - Select Dynamic Range (using End Method)

How to Use 0:10:20

How to Use Arrays Instead of Ranges in Excel VBA

Dynamic Filter with 0:18:49

Dynamic Filter with VBA

VBA Array with 0:15:55

VBA Array with Filter, Sort and Slice (2021)

Excel VBA Macro: 0:14:08

Excel VBA Macro: Autofilter And Copy to New Workbook (Dynamic Range)

I don't use 0:20:32

I don't use OFFSET Anymore! I Use Another Function Instead.

Excel VBA Macro: 0:20:12

Excel VBA Macro: Autofilter, Copy, Paste to New Sheet and Save to Specified Folder (Dynamic Range)

Excel VBA Dynamic 0:08:17

Excel VBA Dynamic Ranges

How To Select 0:08:47

How To Select Dynamic Range In Excel VBA Macros

Dynamic Charts That 0:05:33

Dynamic Charts That Update Automatically In Excel - Using OFFSET To Create Dynamic Ranges

Difference between Dim 0:00:23

Difference between Dim and ReDim in Excel VBA

The Ultimate Excel 0:53:17

The Ultimate Excel Advanced Filters In VBA [Full Training Course]

Excel VBA Advanced 0:09:21

Excel VBA Advanced Filter on Date Range

VBA code for 0:06:47

VBA code for dynamic range in ms Excel

Excel VBA Macro: 0:14:19

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

Use dynamic named 0:02:03

Use dynamic named ranges so your charts update automatically

How to get 0:15:41

How to get the Last Row in VBA(The Right Way!)

Excel VBA Code 0:05:07

Excel VBA Code to Filter with AND Criteria in an Excel Table

How to Make 0:13:54

How to Make a Search Box in Excel with Interactive and Dynamic Buttons | Filter with Macro

Excel: Copy Filtered 0:07:25

Excel: Copy Filtered Data to Another Worksheet Automatically | Advanced Filter (With VBA) & FILT...

The Ultimate Guide 0:31:05

The Ultimate Guide to Copying Data using Excel VBA

Effortlessly Create Dynamic 0:10:15

Effortlessly Create Dynamic Charts in Excel: New Feature Alert!

Комментарии
Автор

If I enter a value in textbox1 and then in textbox2 and then delete the value in textbox2 it triggers the error

Dan_De_Man
Автор

Hello sir, maybe you can help me I made code in Vba but it is long now I would like to make it smaller
Here part of the code:
Application.ScreenUpdating = False
If Sheets("Menu").Range("E2") = 1 Then
Sheets("toplay1").Select
Range("A1").Select
ActiveCell.Formula2R1C1 = _
"=FILTER('S1'!R[1]C[1]:R[20]C[1], 'S1'!R[1]C[1]:R[20]C[1]<>" "")"
Range("B1").Select
ActiveCell.Formula2R1C1 = _
"=FILTER('S1'!R[1]C[5]:R[20]C[5], 'S1'!R[1]C[5]:R[20]C[5]<>" "")"
The Range continues until "J1" you also notice that at "c[ ] each time 4 are added, that is because the search area moves 4 columns each time, if you can help me with this I will be able to continue with the rest I think, can you help me PLEASE
What I forgot is that the number of rows being searched is 20.

gerardvaneggermond