difference between xlfilterinplace vs xlfiltercopy?

[daveyc18]

Range("a1:" & lastcol & finalrow).AdvancedFilter xlFilterInPlace, criteriarange:=thisworkbook.sheets("filter").Range("client_profit_summary_filter")


Range("a1:" & lastcol & finalrow).Copy

ThisWorkbook.Sheets("Client Profit Summary").Activate

Range("a1").PasteSpecial xlPasteValues


...........


basically filtering the data, copying it, then pasting to another workbook...curious if xlfiltercopy could achieve the same thing? what's the difference?

 

[dmt32]

basically filtering the data, copying it, then pasting to another workbook...curious if xlfiltercopy could achieve the same thing? what's the difference?

The VBA helpfile should answer the question
Range.AdvancedFilter method (Excel)
XlFilterAction enumeration (Excel)

not tested but maybe

Range("a1:" & lastcol & finalrow).AdvancedFilter.AdvancedFilter Action:=xlFilterCopy, _
                CriteriaRange:=Range("client_profit_summary_filter"), _
                CopyToRange:=ThisWorkbook.Worksheets("Client Profit Summary").Range("a1"), _
                Unique:=False

Dave