Greetings,
I am trying to copy and paste 117,000 rows of data from one worksheet to another. The method I use is CTRL+SHIFT+END.
I get the following error:
"The information cannot be pasted because the copy area and the paste area are not the same size and shape" with some lame suggestions.
I know that I can get around this issue by holding shift and then going up/down the entire worksheet, but to do so for 117,000 would be more tedious than watching most of the flashback sequences on Lost.
Any way around this?
Thanks,
Bryce
Bookmarks