Dynamic Filtering - Filter Driven By Value in Another Cell

[garylundblad]

Is there a way to have a list filtered automatically by the value in another cell?

Thank you!!!

Gary

 

[NARAYANK991]

Hi ,

Yes.

Narayan

 

[Syedali]

Hi,
You can use "Indirect" formula to do this.

 

[Nebu]

Hi:

Hope this is what you are looking for ....

you can also go through the following link to learn more about dependent drop downs...
http://chandoo.org/wp/2014/02/25/robust-dynamic-cascading-dropdowns-without-vba/
Thanks

 

[garylundblad]

I think I may not have described my question very well. What I'm wanting to do is to have a table, or non-table for that matter, apply a filter automatically based on the change of a specific cell value. For example, I have a statement for my son's Boy scout troop. When I choose a name at the top of the statement, I want the table of transactions below to automatically filter to the name chosen above, so you don't have to pick from the drop down list, and then filter the table also. I'm including a copy of the workbook I'm working on.

Thank you, and I'm sorry for not explaining my question better.

Gary

 

[NARAYANK991]

Hi Gary ,

See this file.

Narayan

 

[garylundblad]

You are my new favorite person Narayan! How did you do it?

Thank you!!

Gary