I hope somebody can help me. I need to repeat an action many time. I put a filter with initial from a list and copy the data in a sheet and save it.
ActiveSheet.Range(A1:T788).Autofilter Field:=8, Criterial:"TFB"
I am using a macro to filter several arguments.
Using 4 cells to define my filters. But if I leave any of them blank, the filter returns with no results.
How do I write the macro to ignore if the cell is left bank?
' Filter Macro
Hi I am trying to copy paste filtered data using VBA onto another workbook under 4 separate sheets but it doesnt seem to work
' Macro1 Macro
ActiveSheet.ListObjects("Table132415").Range.AutoFilter Field:=3, Criteria1 _...