@bradedgarddotcom when I apply the filters, using CTRL+SHIFT+L my whole sheet moves. By this i mean it scrolls all the way over to column WVT. Any thoughts on how to turn that off?
+StevenMartin99VᴇVO Just like anything else in Excel, you could come up with the same result in many different ways. Using strictly VBA would cut out the CF requirement for sure. In using CF in this video the idea was to at least minimize the amount of VBA required. Whether or not this is the most efficient method of handling this, when I thought about it, it was just another unique way developing a solution to a problem.
hi I got error message Object variable or With block variable not set (Error 91) My Module Sub ApplyFilter() ActiveSheet.AutoFilter.ApplyFilter End Sub Private Sub Worksheet_Change(ByVal Target As Range) Call ApplyFilter End Sub Please advise
Didn't work for me either but I figured out why. The dataset I was using was exported from an ERP system and it must have formatted the sheet in a non-default way. To figure this out, I just used the built in macro recorder, named it "ApplyFilter" and recorded me clicking the "apply" filter button. I looked at the code in the module and I could see what was wrong. The code to apply the filter looked like this: ActiveSheet.ListObjects("NavDataRegion3").AutoFilter.ApplyFilter I just replaced ActiveSheet.AutoFilter.ApplyFilter with that line above and it worked. You have to add the record Macro button to your menu somewhere unless there's a keyboard shortcut for it. It also doesn't work if you have locked cells on a protected sheet.
Thanks Mate , you saved me a lot of work
You're welcome glad it helped !
Thank you very much
You saved me
Glad to hear that thanks for checking things out!
Hay man thanks for the video, can you please creat another one for multiple drop-down 2 condition or 3 in VBA
How to use the same procedure to filter multiple columns, For example Col C & Col D in above example???
@bradedgarddotcom when I apply the filters, using CTRL+SHIFT+L my whole sheet moves. By this i mean it scrolls all the way over to column WVT. Any thoughts on how to turn that off?
If you are going to use VBA, why would you use CF? Wouldn't you just set the filter value to the new cell value when that cell is changed?
+StevenMartin99VᴇVO Just like anything else in Excel, you could come up with the same result in many different ways. Using strictly VBA would cut out the CF requirement for sure. In using CF in this video the idea was to at least minimize the amount of VBA required. Whether or not this is the most efficient method of handling this, when I thought about it, it was just another unique way developing a solution to a problem.
+bradedgardotcom hi, pls advice me how to filter drop down list.
hi
I got error message
Object variable or With block variable not set (Error 91)
My Module
Sub ApplyFilter()
ActiveSheet.AutoFilter.ApplyFilter
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Call ApplyFilter
End Sub
Please advise
yeahhhh didnt work. literally followed every single one of your steps to percision
Didn't work for me either but I figured out why. The dataset I was using was exported from an ERP system and it must have formatted the sheet in a non-default way. To figure this out, I just used the built in macro recorder, named it "ApplyFilter" and recorded me clicking the "apply" filter button. I looked at the code in the module and I could see what was wrong.
The code to apply the filter looked like this:
ActiveSheet.ListObjects("NavDataRegion3").AutoFilter.ApplyFilter
I just replaced ActiveSheet.AutoFilter.ApplyFilter with that line above and it worked. You have to add the record Macro button to your menu somewhere unless there's a keyboard shortcut for it.
It also doesn't work if you have locked cells on a protected sheet.