Please help how to write an Marco to do the following.
When using autofilter, the first row is the heading. I want to copy only the result after the auto-filter to another worksheet.
I cannot use copy all function as it will copy the column header as well.
If use the 1 row down, it doesn't know which row to start as the filter result is not the same every time.
How can I write it?