Instant Auto Filter
Closed
Ronny
-
13 Feb 2012 à 17:44
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 20 Feb 2012 à 09:14
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 20 Feb 2012 à 09:14
Related:
- Instant Auto Filter
- Android auto apk - Download - Other
- Qq instant messenger - Download - Instant messaging
- What is auto download mms - Guide
- Nvidia auto detect - Guide
- Filter unknown senders android - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
16 Feb 2012 à 10:09
16 Feb 2012 à 10:09
Hi Ronny,
Try this code:
When you clear the contents of D9, the autofilter will show all data again.
Best regards,
Trowa
Try this code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("D9")) Is Nothing Then Exit Sub
Range("D10").AutoFilter Field:=1, Criteria1:=Range("D9").Value
If Range("D9").Value = "" Then Range("D10").AutoFilter Field:=1
End Sub
When you clear the contents of D9, the autofilter will show all data again.
Best regards,
Trowa
16 Feb 2012 à 13:26
However, I am having trouble getting the event macro going - How do I get it going? I don't think the code is being used at all.
All I did was right-click on the sheet, view code, and paste it in the code area - But I don't think it is being used at all. Am I doing it wrong?
Thanks so much,
Ronny
20 Feb 2012 à 09:14
As far as I can tell you implemented the code correctly.
The code will only be activated when a change is made in cell D9.
Besides that the autofilter must already be applied to cell D10.
To be complete as I can, you can find a download link below for the workbook I created to tackle your query.
http://speedy.sh/TEGMC/Ronny-IAF.xls
Just fill in the letter a, b or c in D9 for the autofilter in D10 to adjust and display the desired result below. Remove the contens of D9 for the autofilter to reset.
If you still get no action from Excel then check if macro's are enabled.
Best regards,
Trowa