greetings
I'm searching for a macro to copy the cells that have been filtered into Auto Filter (Visible cells), and Paste Values into another worksheet
Problem description :
in worksheet1 has Auto Filter from column A to column Z
you need to copy the Visible filtered cells from column A to column E and paste only the values in the first empty cell of column A in worksheet2
return to worksheet1 and copy the Visible filtered cells from column I to column L and paste only the values in the first empty cell of column F in worksheet2
go back to worksheet1 and copy the Visible filtered cells from column U to column W and paste only the values in the first empty cell of column J in worksheet2
then go back to the worksheet1 and undo all filters, ie Clear All Filters
hugs