I have a file A which has 1000 rows and 7 columns. I have another file B
which has 500 rows and 14 columns. I need to sort file A and copy from sorted
file B some information. If the sorted result in both files is 370 rows in
same order, is it possible to copy visible cells (this I can do) and paste
cells only to visible cells? In Paste - Special there seems not to be
suitable selection :(

Thanks to all previus answers, they have been very helpful!