Auto Filter depending on Cell Value [Solved/Closed]

Report
-
rizvisa1
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
-
Hello,
I have data in a table, lets say the table is (A7:M200) and the Headings in this table is (A7:M7).
Column 1 (A8:A200) is the accounts numbers.
I already selected the Row 7 (the headings in this table) then I made Auto filtering.
Now my request is when I write in Cell (E1) any account number to filter that table (A8:M200) according to this selection in E1.
Thank you in advance for any kind assistant.
Issa

2 replies

Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
756
Use sheet change event to update the filter
44
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 4166 users have said thank you to us this month

It's solved :)

Thank you very much to all your assistance.

Issa
hi the suggestion was good but could u provide me after the filter I want all data to display back
just delete any written text in field "E1"
Ya gud working, but what about when I need that Cell contains to be filtered.
IF More than one field is there
Hello

This has proved really useful but does anybody know how to now do this for multiple selections? i.e filter more than 1 column?

I'm wanting to do this so by answering a couple of questions will help find the right answer....

I could also do with a reset command to remove all filters once done. Any help will be greatly appreciated.

Thanks
Stuart
rizvisa1
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
756
Stuart,
when you say "multiple selections", you mean like "OR" condition on same column or "AND" on various columns