OK, so I have one dataset with thousands of subjects and thousands of variables, and I'm trying to move them in bulk over to another worksheet. It looks like I can copy the filtered ranges without trouble, BUT when I try to bring it over to the new worksheet where I have applied filters to display the target cells where I want the datapoints to go, it wants to paste them into ALL cells, so a bunch of the data disappears into the invisible lines where it doesn't belong.

As a result, I'm stuck copy/pasting THOUSANDS of lines into their target cells. I'm a few hundred lines in now and its already too much. Besides the sheer time it will take, there's also so much more room for me to make errors doing it this way.

Does anyone know a way to tell Excel to copy only FROM a range of selected and visible cells TO an identically-sized range of selected and visible cells, without data disappearing into filtered-out lines?

Thanks in advance...