Auto Filter depending on Cell Value [Solved/Closed]

- Aug 3, 2011 at 05:56 AM - Latest reply:
Posts
4481
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
- Nov 15, 2014 at 05:21 AM
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
See more 

10 replies

Best answer
Posts
4481
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
- Aug 3, 2011 at 10:11 AM
43
Thank you
Use sheet change event to update the filter

Thank you, rizvisa1 43

Something to say? Add comment

CCM has helped 1634 users 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
4
Thank you
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
Posts
4481
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
- Nov 15, 2014 at 05:21 AM
Stuart,
when you say "multiple selections", you mean like "OR" condition on same column or "AND" on various columns