Hi try adapat code below but, display error.

i need filetr by date and copy, but my criteria is another sheet "Corr_KPI" then range("O1") has formulas, when i run code, dysplay error
compilation error:
the object is mandatoryFilterDate.xlsb
Please Login or Register  to view this content.