I just want to copy text with zero format from multiple (5-10) cells in the same column, into a column on a different sheet. I've been working on this for over an hour...sometimes it works, sometimes it pastes text from the first cell in the originating sheet into all the cells in the second sheet, sometimes it pastes the last thing I already copy/pasted from different document earlier, but then sometimes it actually works. I'm doing all of this in the from and to the same two columns so I don't know what the issue is. But it's driving me nuts.
The only way I can get it to work 100% is to copy past one cell at a time, and only if i click and highlight the cell text in the originating sheet first. This is going to take me a week to finish this task.