I have one Excel 2013 worksheet that contains contiguous rows of data - about 14k rows.
I have another worksheet with the relevant rows exposed and visible and I want to paste the 14k contiguous rows into the non-contiguous, but visible-only rows of the second sheet in a blank column.
Can this be done? Any variation of Find and Select > Visible Cells Only won't paste in properly, unless I'm still doing something wrong. I get a message that the two selections are different sizes, but they really aren't - not if we are only talking about the non-contiguous, but visible cells in sheet 2...
Any ideas how to do this?