Hi I tried to build one advance filter and copy to another sheet by macro, VBA is as below, but it looks not working, they always only show the head, could you please advise what issue in there, thanks
Sub log_book()
'
' log_book Macro
'
'
Worksheets("Details").Activate
Sheets("Details").Range("A12:J460").AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Range("A25:J26"), CopyToRange:=Range("AA35"), Unique:=False
End Sub
Bookmarks