Hi all. I have a table (B3:C13) where the first named range ($B3:$B13) is "No.", the second named range ($C3:$C13) is "Name". In C2, I enter a number found in named range "No." of the table. I would like Excel to filter the data containing the number that I entered in C2. Is it possible?
It is quite a hassle clicking the dropdown button and selecting the desired number to be filtered. Thank you.



I found a vba solution. Excel VBA AutoFilter: 19 Step-by-Step Examples to Filter Data with Macros

Attached Files

Dependent Filter.xlsx (9.9 KB, 3 views)

Like this ?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you for the formula. I have spent an hour trying to make this work in a vba code but I keep receiving error messages.