You would need a macro, to open a new workbook, copy the filtered data there
and save the new workbook under a new given path/name, and then close
it.........

Vaya con Dios,
Chuck, CABGx3


"coconutt" wrote:

Is there a way to save a worksheet with only the data of an applied auto
filter?

thanks