field=8

Hi 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" Range(A1:U788).select Selection.copy workbooks.add activesheet.paste How can...

hi sir i have a code here but when i use the path on network the code can't find it but if i use a path not on network it works fine the Bold code is the network path,

Afternoon 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? Sub Filter()' ' 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 Sub Macro1() ' ' Macro1 Macro ' ' ActiveCell.Offset(2703, 1).Range("A1").Select ActiveSheet.ListObjects("Table132415").Range.AutoFilter Field:=3, Criteria1 _...