Automatic Filter by Cell Result

[jamesmev]

I currently have a worksheet that in Cell D9 is an index match formula.
I am looking to filter the data from A16:A133826 based on the result of D9.


Example: D9 = New York

Filters all results of New York that appear within the range of A16:A133826.

I don't know where to being without creating a number of macros which seems overkill and too messy.

Any help?

 

[jamesmev]

i currently have a worksheet that in cell d9 is an index match formula.
I am looking to filter the data from a16:a133826 based on the result of d9.


Example: D9 = new york

filters all results of new york that appear within the range of a16:a133826.

I don't know where to being without creating a number of macros which seems overkill and too messy.

Any help?

solved