Is there a way to save a worksheet with only the data of an applied auto filter? thanks
C coconutt Feb 23, 2006 #1 Is there a way to save a worksheet with only the data of an applied auto filter? thanks
C CLR Feb 23, 2006 #2 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
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
