Auto Filter depending on Cell Value
Solved/Closed
Issa
-
Aug 3, 2011 at 05:56 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 15, 2014 at 05:21 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 15, 2014 at 05:21 AM
Related:
- Excel filter based on cell value without vba
- Excel vba filter based on cell value on another sheet - Best answers
- Excel vba filter based on cell value - Best answers
- Number to words in excel without vba - Guide
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- Enable vba in excel - Guide
- Vba case like - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 3, 2011 at 10:11 AM
Aug 3, 2011 at 10:11 AM
Use sheet change event to update the filter
Aug 4, 2011 at 12:56 AM
Thank you to your prompt reply.
I don't know what you mean by your answer "Use sheet change event to update the filter", how it works?.
I think I need VBA code to do my request? can you provide me with this code.
Thank you again for any kind assistance.
Issa
Aug 4, 2011 at 09:56 AM
1. Open the file
2. Press ALT + F11
3. Press CTRL + R
4. Double click on the sheet where you want this functionality
5. Paste the code
This is based on assumption that you want to filter the 1st column (column A). Change value of "Field" to point to right column
By the way you can use wild card in E1 like
1234* ( some thing that starts with 1234)
123?56??? (some thing that start with 123, then has some character, followed by 56 followed by three charachters
*1234* (some thing that has 1234 some where)