Hello All

I have a filtered sheet, from which I have to copy the data of a specific column. But I don't want to copy the header.
Suppose I have to copy the Column 'M' and there are 3 rows after filtering is done, how do I copy those 3 values of column M?
I cannot do a offset(1,0) from "M1" to go to the first visible row .
Please help.

Thanks in advance.