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?
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?