How do I copy table after I filter it? I have table with 1230 rows and 7 columns from where I want to copy certain 82 rows, by rules like "either column named AT or column named HT has to be the value that I have in cell K1" and then to copy the filtered 82 lines to place M2:S83.

I have understood that Data-Sort&Filter-Advanced should do it, but I have no clue how this "criteria range" works. Some AT=$K$1 filters nothing.